Hi, I just upgraded to Excel 2016 and the customize keyboard option is missing. F9 Calculates all worksheets in all open workbooks. Ctrl+3 Applies or removes italic formatting. Shift+F10 Or, on a Windows keyboard Context key between the right Alt and right Ctrl keys Move to the submenu when a main menu is open or selected. Ctrl+Enter Fills the selected cells with the current entry. Ctrl+1 Displays the Format Cells dialog box.
To display a tab on the Ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. With Scroll Lock on, the arrow keys will not navigate from cell to cell — the only way to move is via mouse or trackpad. To display a tab on the Ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. Thank you for bringing this feature back. Ctrl+Shift+Spacebar selects the entire worksheet. F6 Switches between the worksheet, Ribbon, task pane, and Zoom controls. Alt+Shift+F10 displays the menu or message for an Error Checking button.
Ctrl+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed. Ctrl + C Copy the contents of the selected cells to Clipboard. Ctrl + Home then Ctrl + Shift + End Select the entire range of your actual used data on the current worksheet. End mode turns off automatically after pressing the arrow key. For easily moving around within notebooks, the keyboard shortcuts below can help. Ctrl+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. Alt+R Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros.
Tab Moves one cell to the right in a worksheet. Ctrl+Page Up moves to the previous sheet in a workbook. Alt+Shift+F2 Saves the current worksheet. F2 Expand or collapse the formula bar. Ctrl+Arrow key moves to the edge of the current data region in a worksheet. Shortcut keys are commonly accessed by using the Option, Control, Shift, Function key and Command key. Up arrow key Move one cell down in a worksheet.
Ctrl+S Saves the active file with its current file name, location, and file format. Ctrl+Shift+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. Will my old shortcuts still work? Here are several application-specific shortcuts for the most common actions within each of the five applications. In each pull down menu you will see keyboard commands given in the right side of the window. Ctrl+V Pastes everything copied onto the. Alt+Shift+F10 Display the Function Arguments dialog box when the insertion point is to the right of a function name in a formula. If you know the entire key sequence, go ahead and initiate the command.
If you forget one of these, use the mouse and go to the menu bar. If the cursor is in the formula bar, Ctrl+Shift+End selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar. We would love to hear your feedback about this feature and of course we want to know if you run into any problems, so please click the Smiley-face button in the top corner of the Excel window to send us feedback. Let us show you how to work more efficiently with OneNote. Many users find that using an external keyboard with keyboard shortcuts for Excel for Mac helps them work more efficiently. Ctrl combination shortcut keys Tip: Download or print a Quick Reference Card:.
Tip To search for a specific item, modifier, or function, press Ctrl+F on your keyboard, type in , and then click the up and down arrows to cycle through the options. Ctrl+Z Keyboard shortcuts for working with data, functions, and the formula bar To do this Press Select an entire PivotTable report. Tip: Download or print a Quick Reference Card:. Alt, W, L switches the worksheet to Normal view. Available only after you have cut or copied an object, text, or cell contents. If the worksheet contains data, Ctrl+A selects the current region.
Keyboard Shortcuts to use with a Macintosh Computer You can avoid reaching for the mouse if you are familiar with keyboard shortcuts. Delete Removes the cell contents data and formulas from selected cells without affecting cell formats or comments. F3 Move to the first field in the next record of a data form. Ctrl+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. Also clears the content of the active cell. Ctrl+A Selects the entire worksheet. Ctrl+N Creates a new workbook.
Left arrow key Move one cell right in a worksheet. Ctrl + Home Move to the beginning of a worksheet A1 cell. Ctrl+Shift+End Move to the cell in the upper-left corner of the window when Scroll Lock is turned on. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. Ctrl + V Insert the contents of the Clipboard into the selected cell s.