Do you work with Microsoft Office on a regular basis? If so, you’ll love this refresher on these essential function-key shortcuts on your keyboard. Have fun.
- 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.
- 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.
- 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.
- Spell Check. F7 opens the Spell Check dialog box in Excel, Word, and Outlook.
- 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.
- Change Case in MS Word. 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.
- Repeat last action in MS Word. 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.
- Thesaurus in MS Word. Shift-F7 opens the Thesaurus dialog and suggests synonyms for the selected word.
- Disable hyperlinks in MS Word. 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.
- Edit a cell in MS Excel. F2 edits the active cell (text and formulas)–a quick and easy way to manage formulas.
- Insert Function in MS Excel. 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.
- Create cell reference in MS Excel. F4 toggles thru formulas to create absolute or relative cell references. In this case, the graphic below is worth a thousand words for explaining this feature.
- Display Macro dialog box in MS Excel. Alt+F8 displays the Macro dialog box, which provides the options to Run, Step Through, Edit, Delete, or customize any macro.
- Calculate the active worksheet in MS Excel. It takes time to recalculate a really huge worksheet, especially if it’s loaded with formulas. So, many power users turn off the “auto-calculate” feature (File>Options>Formulas, then click Manual under Calculation Options-Workbook Calculation). Once disabled, you’ll be able to work more quickly, When you’re finished entering and editing text and formulas, press Shift-F9 to recalculate everything.
- Create a chart with data in current range in MS Excel. F11 creates a chart of the data in the active range of the active worksheet. However, highlighting the range first could save time when editing the chart.
information source: it news