If the cells are blank, pressing End followed by an arrow key moves to the last cell in the row or column. These are categorized by Excel shortcuts with function keys, Excel shortcuts with Control key and Miscellaneous. This makes all the Key Tip badges for that tab's buttons appear. Available only after you have cut or copied an object, text, or cell contents. In End mode, you can press an arrow key to move to the next nonblank cell in the same column or row as the active cell. Alt+ C Displays the Collection List task pane.
Function keys Key Description F1 Displays the Excel Help task pane. This article itemizes the keyboard shortcuts for Excel for Windows. Backspace Delete one character to the left. Ctrl+Spacebar Select an entire row in a worksheet. When a ribbon tab is selected, these keys navigate up or down the tab group.
Arrow Up Move up one line. Ctrl+Shift+End Move to the cell in the upper-left corner of the window when Scroll Lock is turned on. Ctrl+F7 performs the Move command on the workbook window when it is not maximized. Use them to keep both hands on the keyboard and navigate faster, creating charts, workbooks, and data groups with all the ease of some kind of super-calculating super-computer. Shift+ F9 Calculates the active worksheet. In a PivotTable, it selects the entire PivotTable report. Press a third time to select the entire worksheet.
Alt+W Work in the ribbon with the keyboard To do this Press Select the active tab of the ribbon, and activate the access keys. Ctrl+G Go to a certain area. For example, on the Home tab, the Number group includes the Number Format command. Ctrl+U or Ctrl+4 Apply or remove strikethrough formatting. Moves to the next option or option group in a dialog box. Tab Open the list of validation choices on a cell that has data validation option applied to it. Ctrl+Shift+: Enters the current time.
Shift+F3 Copy the value from the cell above the active cell into the cell or the formula bar. Shift+F6 Move to previous pane. Shift+Arrow key Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell. Ctrl+F10 maximizes or restores the selected workbook window. Clear a character to left side while editing or writing content in cell. Ctrl+Shift+Page Down selects the current and next sheet in a workbook. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
Shift+ F10 Display the shortcut menu for the selected command. Available only after you have cut or copied an object, text, or cell contents. Ctrl+Shift+O selects all cells that contain comments. If the cursor is in the formula bar, Ctrl+End moves the cursor to the end of the text. The Ribbon groups related commands on tabs.
F3 Displays the Paste Name dialog box. Ctrl+O Displays the Open dialog box to open or find a file. Excel for Office 365 Word for Office 365 Outlook for Office 365 PowerPoint for Office 365 Access for Office 365 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 OneNote 2016 Access 2019 Visio Professional 2019 Visio Standard 2019 Project Professional 2019 Office 2016 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 OneNote 2013 Access 2016 Visio Professional 2016 Visio Standard 2016 Project Professional 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Access 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 OneNote 2010 Access 2010 Excel 2007 Word 2007 PowerPoint 2007 Office 2007 Office 2010 Office 2013 Project Online Desktop Client Visio Online Visio Online Plan 2 This article gives you links on how to use shortcut keys keyboard shortcuts in apps for Office. Ctrl+W Closes the current workbook. F10 Highlights shortcut keys of Menu and Ribbon items. F5 Displays the Go To dialog box. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu.
Ctrl+ ' Copies a formula from the cell above the active cell into the cell or the Formula Bar. Ctrl+Shift+Page Up selects the current and previous sheet in a workbook. Shift+F2 Open the Insert dialog to insert blank cells. Shift+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon. If the worksheet contains data, Ctrl+A selects the current region. Closes an open menu or submenu, dialog box, or message window. Alt+Page Up moves one screen to the left in a worksheet.