F2 Moves the insertion point to the end of the contents of the active cell. For example, select cell B6 below and press F2.
Note: turn off Allow editing directly in cells (File, Options, Advanced, Editing Options) and pressing F2 will move the insertion point to the formula bar. F3 Displays the Paste Name dialog box. For example, select cell E2 below, type =SUM(, press F3 and select a name. Note: of course, first create at least one. F4 Cycles through all 4 types of (absolute, mixed reference (2x) and relative). For example, select cell B5 below, click in the formula bar, move the insertion point in or to the right of G2, and press F4.
Note: if you are not editing a cell, F4 repeats the last action, if possible. F5 Displays the Go To dialog box. For example, to select cell C15, in the Reference box, type C15, and click OK.
Note: you can also select named ranges, or click to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc. F6 Moves to the next pane in a worksheet that has been. F7 Displays the dialog box (the same as clicking Spelling on the Review tab). F8 Turns on/off Extend mode. If Extend mode is turned on, select cell A1 and press → and ↓ a few times. Note: if Extend mode is turned off, hold down SHIFT and press → and ↓ a few times. F9 Calculates the workbook.
Fixing the F4 Button in Excel for Mac The F4 key in Excel for Windows is normally a shortcut key to Repeat the last command. In Excel for Mac the F4 key is assigned to the Paste command, which is driving me crazy so I decided to do something about it. This doesn't seem to work in Mac Excel 2016. After a bit of digging, it looks like the key combination for entering the array formula has changed from. Select the desired range of cells; Press Fn + F2 or CONTROL + U; Paste in your array value.
By default, any time you change a value, Excel automatically calculates the workbook. Turn on Manual calculation (on the Formulas tab, in the Calculation group, click Calculations Options, Manual) and change the value in cell A1 from 5 to 6. Note: if you are editing a cell, F9 replaces a formula with its own result. F10 Shows the key tips (the same as pressing ALT). Key Tips allow you to quickly perform any task available on the Ribbon without using the mouse. F11 Creates a of a selected range. F12 Brings up the Save As dialog box.
Note: to change the default file location, on the File tab, click Options, Save.
This article is for people with visual impairments who use a screen reader program with the Office products and is part of the content set. For more general help, see. Many users find that using an external keyboard with keyboard shortcuts for Excel for Mac helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse. This article itemizes the keyboard shortcuts for Excel for Mac. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel for Mac.
However, not all do. Note: Changing system function key preferences affects how the function keys work for your Mac, not just Excel. After changing this setting, you can still perform the special features printed on a function key. Just press the FN key. For example, to use the F12 key to change your volume, you would press FN+F12.
If a function key doesn't work as you expect it to, press the FN key in addition to the function key. If you don't want to press the FN key each time, you can change your Apple system preferences: Change function key preferences with the mouse.
On the Apple menu, press System Preferences. Select Keyboard. On the Keyboard tab, select the check box for Use all F1, F2, etc.
Keys as standard function keys.