Excel Keyboard Shortcuts Get a list of Excel keyboard shortcuts, or use the interactive list, shown below. Do you use keyboard shortcuts in Excel? F9 Calculates all worksheets in all open workbooks. Moves between unlocked cells in a protected worksheet. Spacebar or Enter Open the list for a selected command. Also restores 'un-maximizes' all workbook windows. Press either of these keys again to move back to the document and cancel the access keys. Ctrl+F7 performs the Move command on the workbook window when it is not maximized.
If you're the kind who prefers clicking keys over mouse buttons, you'll find that using shortcuts will help you get your project or report done in less time. Ctrl+Y Repeats the last entry. Many users find that using an external keyboard with keyboard shortcuts for Excel for Mac helps them work more efficiently. There's a service check that happens when you restart, and sometimes it takes more than one try to get the latest Insider Fast settings. Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Many users find that using an external keyboard with keyboard shortcuts for Excel for Windows helps them work more efficiently. Ctrl+Y Repeats the last command or action, if possible. Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel 2013.
Pressing F5 displays the same dialog. Left arrow key Excel keyboard shortcut reference Keyboard shortcuts for navigating in cells To do this Press Move to the previous cell in a worksheet or the previous option in a dialog box. Ctrl+D Apply the General number format. Ctrl+Shift+O Selects all of the cells that contain comments. Shift+F3 Opens the Excel window. Used to be ctrl+ shift+ p, but that seems just get to the Font Tab in 2010.
Work with the Excel Ribbon Ctrl+ F1 Minimize or restore the Ribbon. Formula bar will show this as e. Ctrl+ Shift+ A Insert Arguments in formula after typing formula name. Select table as necessary but many times Excel figures out what you want. Ctrl+F8 performs the Size command on the Control menu for the workbook window when a workbook is not maximized.
It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again. Ctrl + X Cut the contents of the selected cells to Clipboard. Ctrl+Z Keyboard shortcuts for working with data, functions, and the formula bar To do this Press Select an entire PivotTable report. Auto Filter Alt+ Arrow Down On the field with column head, display the AutoFilter list for the current column. Shift+F5 also displays this tab, while Shift+F4 repeats the last Find action.
Ctrl+Shift+% Applies the Percentage format with no decimal places. Alt+Enter starts a new line in the same cell. Closes an open menu or submenu, dialog box, or message window. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region. Ctrl+T Displays the Create Table dialog box. Alt+M Open the Data tab and connect to, sort, filter, analyze, and work with data. Shift+F8 Start a new line in the same cell.
Ctrl+Shift+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. For example, try pressing Alt, and then press one of the old menu keys E Edit , V View , I Insert , and so on. Alt+Shift+F10 Display the Function Arguments dialog box when the insertion point is to the right of a function name in a formula. Ctrl+C Copies the selected cells. Thank you for bringing this feature back. Ctrl+ Shift+ Page Up Select the current and previous sheet in a workbook.
Pressing Ctrl+Shift+Spacebar a second time selects the current region and its summary rows. Press Alt again to see KeyTips for the commands on any tab. Press Ctrl + PgUp to switch to the previous sheet. Ctrl+End moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. Ctrl+0 Hides the selected columns. Manual Calculation F9 Calculate all worksheets in all open workbooks Shift+ F9 Calculate the active worksheet Ctrl+ Alt+ F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation Ctrl+ Alt+ Shift+ F9 Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated Open and Save Workbooks Ctrl+ O Open file via standard open dialog box Alt+ F, O File Open via Excel file manager Alt+ F, O + 1. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color.