For Excel
- Ctrl+Shift+!—Applies the number format with two decimal places, thousands separator and minus sign ( - ) for negative values.
- Ctrl+Shift+$—Applies the currency format with two decimal places (negative numbers in parentheses).
- Ctrl+Shift+%—Applies the percentage format with no decimal places.
- Ctrl+Shift+#—Applies the date format with the day, month and year.
For Word
- When replacing text with new text, you don’t have to use the Delete key. Instead, select the old text, and as you start to type, the old text will vanish.
- A quick way to toggle Print Preview: press Alt+Ctrl+I. Press it again (or Esc) to return to normal view.
- If you type something and then change your mind, press Ctrl+Backspace to delete a word at a time. And if you get overzealous, press Ctrl+Z to bring it all back.
For Windows
- Best time to defrag: right after a restart. This allows the operating system to clear out files in memory and lets the defrag tool focus on the hard disk data.