Excel “Secret Menus”

There are two “secret menus” that I bet almost all of you never saw on an Excel Sheet!
To see the first one, let’s click on a sheet cell and then move the mouse over any border of the cell until the mouse pointer changes to a set of arrows. Then right click it and drag to the destination cell and release the mouse. A set of options like this will appear:
 
SecretMenus1
 
To see the second “secret menu”, put a date on a cell and move the mouse over the bottom right corner of the cell until the mouse pointer changes to a small filled black cross. Now you can right click it and drag to the destination cell. A menu with a set of options will appear:
 
SecretMenus2

2 comentários:

Anonymous said...

Nice tips!

InterPol said...

Here's another one: Hold the shift key and click the menu Edit. The Copy/Paste/Paste special change to Copy Picture/Paste picture and Paste picture link.