Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.Įxtend the selection of cells to the last used cell on the worksheet (lower-right corner). If the cells are blank, move to the last cell in the row or column. Move to the edge of the current data region in a worksheet.Įnter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. Move to the previous cell in a worksheet or the previous option in a dialog box. Move from one group of controls to another.

Move to the submenu when a main menu is open or selected. When a menu or submenu is open, move to the next command.

Show the tooltip for the ribbon element currently in focus. Move down, up, left, or right, respectively, among the items on the ribbon. Move the focus to commands on the ribbon. Select the active tab on the ribbon and activate the access keys. To move to a different tab, use access keys or the arrow keys. 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.Īlt or F10. Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and workbooks. Open the Data tab and connect to, sort, filter, analyze, and work with data. Open the Formulas tab and insert, trace, and customize functions and calculations. Open the Page Layout tab and work with themes, page setup, scale, and alignment. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes. Open the Home tab and format text and numbers and use the Find tool. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content. Download shortcut key as PDF file for offline usage. List of MS Excel Shortcut Keys PDF View and Download the latest updated Excel Shortcut Keys for Excel 201 3, 2010, 20.

Excel shortcut keys pdf 2007