Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

The 15 function-key strokes everyone should know to zip around Microsoft Office

Michael Ansaldo | Jan. 16, 2015
Despite Microsoft Office's evolution toward menu-driven shortcuts, it's worth remembering those funky Fn keys still serve a purpose. As part of key combos in Word, Excel, and Outlook, they make it easier and faster to perform commonly used commands.

Despite Microsoft Office's evolution toward menu-driven shortcuts, it's worth remembering those funky Fn keys still serve a purpose. As part of key combos in Word, Excel, and Outlook, they make it easier and faster to perform commonly used commands.

Here are 15 of the most essential function-key strokes. Once you get the hang of two-fisted input using the mouse and keyboard shortcuts, you'll find yourself shaving hours off your projects.

Universal keystrokes

1. Help

F1 is the Help key in almost every software program available, including all the Microsoft products. Ctrl+F1 displays or hides the ribbon menu bar in Word and Excel.

2. GoTo

F5 is the GoTo key in both Word and Excel. Excel displays a dialog box prompting for a cell reference such as B55 or G12. Word's dialog box prompts for 13 different locations, including the page, section, line, table and graphic.

3. Toggle between documents

Ctrl+F6 toggles between multiple Word documents when you have more than one open, or between worksheets when you have more than one Excel file open.

4. Spell Check

F7 opens the Spell Check dialog box in Excel, Word, and Outlook.

5. Save

Shift-F12 saves the current document, spreadsheet, or whatever task is currently open in Outlook (email, contact, task, etc.). F12 opens the Save As dialog box in Excel, Word, and Outlook, then prompts for a new filename.

Word

6. Change Case

Shift-F3 toggles the case of the selected text (in Outlook as well), rotating from sentence case to uppercase to lowercase and so on. Just highlight the text you want to format and continue to press Shift-F3 until the case you want appears. No more deleting text when you accidentally press the Shift key in the middle of a word or forget the Caps Lock key is turned on.

7. Repeat last action

F4 repeats the last action you performed. For example, create a text box, insert a graphic, or draw a line, then press F4 and the action is duplicated.

8. Thesaurus

Shift-F7 opens the Thesaurus dialog and suggests synonyms for the selected word.

9. Disable hyperlinks

Hyperlinks can be deactivated one at a time through the right-click menu. But removing dozens of hyperlinks from a document using this method takes time. Ctrl+Shift-F9 also disables one active hyperlink when it's selected. But to disable all active hyperlinks in a document, first press Ctrl+A to select the entire document or email, then press Ctrl+Shift-F9.

Excel

10. Edit a cell

F2 edits the active cell (text and formulas) — a quick and easy way to manage formulas.

11. Insert Function

Place your cursor in the target cell, then press Shift-F3 to open the Insert Function dialog. Choose a function from the list (SUM, AVERAGE, IF, COUNT, etc.) and click OK. Next, the Function Argument dialog opens, prompting for the range you want to calculate using the function you just selected. If the target cell is below a column of numbers, Excel automatically enters the range above the target cell. Once the range is determined, click OK. Excel enters the function/formula plus range and calculates the answer.

 

1  2  Next Page 

Sign up for MIS Asia eNewsletters.