Ctrl+ Shift+ Apply the Date format with the day, month, and year. Shift+Arrow key extends the selection of cells by one cell. Shift+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon. Entering data F2 Edit the current cell. Learn the top 10 Excel formulas every world-class financial analyst uses on a regular basis.
Ctrl+Shift+Home extends the selection of cells to the beginning of the worksheet. Down arrow key Open the menu for a selected button. Ctrl+X Copy the selected cells. F5 Goes to a specific cell. Esc Cancels an entry in the cell or Formula Bar.
There are also a few other combos for speeding up selection, as well. Moves to the cell in the upper-left corner of the window when Scroll Lock is turned on. For example, type Shift + H this would assign Control + Shift + H as the shortcut. Alt+ Enter outside edit cell mode Repeat last action. Shift+Enter Select an entire column in a worksheet. I list them in the tables below. In cell editing mode, it deletes the character to the right of the insertion point.
Use arrow keys and shift+ arrow keys to add to selection. Ctrl+Arrow key moves to the edge of the current data region in a worksheet. Ctrl+ 5 Apply or remove strikethrough formatting. F10 Turns key tips on or off. Just enter your email address below to get access to Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet now! Thank you for bringing this feature back. Ctrl+Shift+Page Up selects the current and previous sheet in a workbook. However, it still does not address all of the keyboard shortcuts that were available in Excel 2011 for Mac.
Ctrl+Page Up moves to the previous sheet in a workbook. Pressing Alt does the same thing. Spacebar In a dialog box, performs the action for the selected button, or selects or clears a check box. F5 Displays the Go To dialog box. Ctrl + Enter Fill the selected cells with the contents of the current cell. In End mode, you can then press an arrow key to move to the next nonblank cell in the same column or row as the active cell. If a column has been selected, then the column will be duplicated in the column to the right.
Ctrl+1 Format fonts in the Format Cells dialog box. In cell editing mode, it deletes the character to the left of the insertion point. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. Shift+Page Down In a single column, highlights all cells above that are selected. F3 Move to the first field in the next record of a data form. In a worksheet that has been split View menu, Manage This Window, Freeze Panes, Split Window command , F6 includes the split panes when switching between panes and the Ribbon area. Or, if editing is turned off for the cell, move the insertion point into the formula bar.
For example, on the Home tab, the Number group includes the Number Format command. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. Shift+F3 Copy the value from the cell above the active cell into the cell or the formula bar. F9 Calculates all worksheets in all open workbooks. Alt+F8 displays the Macro dialog box to create, run, edit, or delete a macro. F7 Spell check selected text or document. Closes an open menu or submenu, dialog box, or message window.
Am I doing something wrong? Alt+Spacebar displays the Control menu for the Excel window. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. Page Up Move one screen to the left in a worksheet. Ctrl+; Enters the current date. You can now assign your own key combinations to many commands within Excel.
Opens a selected menu press F10 to activate the menu bar or performs the action for a selected command. Ctrl + Home Move to the beginning of a worksheet A1 cell. Enter Filter the list by using the selected item in the AutoFilter list. Updated to the Insider Fast version referenced above, but I'm not seeing a Customize Keyboard command under the Tools menu — or anywhere else for that matter. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu.