If you do not spell very well and your boss pays attention to spelling, please make sure you press F7 before sending your Excel reports. Otherwise, your boss may challenge your spelling instead of your analysis. 🙂
F7 key is mainly for word-related functions:
- F7 alone – Open the Spell Check
- Shift+F7 – Open the Research Task Pane
Ctrl+F7 – Allow you to move window of workbook when it is not maximized.
F7 alone – Open the Spell Check
This one is quite obvious. As a side topic, many people do not have a habit of spell-checking before sending their Excel reports. I guess that these people rely heavily on the “red-underscore” which informs you instantly when there is a spelling mistake, in WORD and PowerPoint, and other word processing applications. However, please bear in mind:
Excel is not a word processing application. It will not do spell check for you until you ask Excel to do so.
Shift+F7 – Open the Research Task Pane
Notes:
- If you press Shift+F7 in a blank cell, it opens the Research Pane with nothing to search for. You need to input what you want to search for.
- Alt+Click does the same thing.
Ctrl+F7 – Allow you to move window of workbook when it is not maximized.
Note: Move with your mouse (of course). When done, press Enter or Esc.
This is another shortcut that I have never used (except for this post)… 😛
Note:
The shortcut combinations stated above have been tested with Excel 2010. If you find it doesn’t work in other version of Excel, please let us know by leaving your comment.
Also feel free to share your tips in using F7 key.
For other Function keys:
wmfexcel 