Select text; Ctrl+Spacebar will remove all formatting from the highlighted text.
Repeat Action
To repeat the last action that you’ve just taken, select a cell or a range of cells where you want to repeat it and press the function key – F4. You can repeat this over and over.
Today’s Date
To insert Today’s date use Ctrl+; (semicolon) on the keyboard.
Cell Navigation
To move through a group of cells that you’re working on (without going outside the range) highlight the group of cells and then use the “Enter” key to move through them.
Format Painter
MS Office Tip: Double-clicking on the Format Painter icon will cause it to “stick”, so that you can continue to apply the desired format to multiple places. To turn this tool off, either press the Esc key or click the Format Painter icon again.
Hide the Ribbon Bar
CTRL+F1 to toggle between hiding/un-hiding the Ribbon Bar in 2010.
Copy and Paste without formatting
In 2010 if you want to copy and paste only the text but not the formatting, on the Home tab click the arrow under the Paste button for Paste Options and select Keep Text Only.
Closed a document without saving?
Word 2010. 1. Go to the File tab –> Info –> Manage Versions. 2. Click on the little dropdown and select Recover Unsaved Documents. 3. Word will open up the folder UnsavedFiles, (where it keeps a copy of the draft document). Select the document you want and click the Open button.
Make tabs stand out
Right-click on tab and select Tab Color.
Cycle through open spreadsheets
Hold CTRL while hitting Page Up and Page Down (in Macs hold Fn also) and you can go from one sheet to the next.
