F7 – It is about word

Excel Tips - F7 (0)

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

Excel Tips - F7

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 Tips - F7 (0)

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

Excel Tips - Shift+F7

Notes:

  1. 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.
  2. Alt+Click does the same thing.

Ctrl+F7 – Allow you to move window of workbook when it is not maximized.

Excel Tips - Ctrl+F7

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:

F1  F2  F3  F4  F5  F6  F7  F8  F9  F10  F11  F12

Advertisements
This entry was posted in Shortcut and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s