excel keyboard shortcuts and function keys for mac

The Complete List of MS Excel Function Key ( F 1 to F 12 ) Shortcuts.

What we will do is limit our scope and concentrate only on Function Keys today.

We will try and learn the actions associated with F1 through F12, standalone and in combination with keys like Alt, Ctrl and Shift.

We all know the basic moves like how you can move around the sheet and select cells using the arrow keys or press CtrlA to select the entire worksheet but there are more complicated shortcut keys that you should know.

Must Read: If you wish to explore basic and general uses of function keys read out post on the best and default uses of function keys.

F2 Shortcut Key Action F2 Activates the active cell for editing.

F3 Shortcut Key Action F3 Paste a defined name into a formula.

F4 Shortcut Key Action F4 Repeat last action (for example, create a text box) or toggle among cell references.

Selection toggles only until the cell that contains data then goes to the next row.

F6 Shortcut Key Action F6 Switch between the Help task pane and the application window.

CtrlF6 Switch to the next workbook window when more than one workbook window is open.

ShiftF6 Switch to the previous pane in a worksheet that has been split.

CtrlShiftF6 Switch to the previous workbook window when more than one workbook window is open.

F7 Shortcut Key Action F7 Perform spell check in the selected range.

CtrlF8 Activate resize window cursor provided window is not maximized.

ShiftF8 Enable Add to Selection mode - select non-adjacent cells when enabled.

ShiftF9 Calculate the active worksheet CtrlAltF9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CtrlAltShift F9 Recheck dependent formulas and then calculates all cells in all open workbooks.

F10 Shortcut Key Action F10 Select the menu bar and close an open menu and submenu at the same time.

F11 Shortcut Key Action F11 Create a chart of the data in the selected range.

CtrlF11 Create new worksheet with name like Macro1, Macro2 AltF11 Switch between the visual basic editor and the active workbook.

Cool Tip: Did you know that you can just press Esc to expand or collapse the formula bar and Delete to remove cell contents Well, now you know.

Conclusion So, did you find the list interesting If you spend most of your day on Excel, I am betting you must have found it helpful.

Excel Keyboard Shortcuts And Function Keys For Mac