F7 – It is about word - EBOOK VBA EXCEL

EBOOK VBA EXCEL

EVBA.info ( Ebook VBA Excel ) Welcome EVBA.info - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Search This

Monday, December 2, 2019

F7 – It is about word

F7 – It is about word

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)…  
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment