Microsoft Office Excel Shortcuts
Categories
|
|
Worksheet ShortcutsInsert worksheet . . . . . . . . . . . . . . . . . . . . . .[Alt] > [H] > [I] > [S]
Move to the next sheet in the workbook. . .[Ctrl] + [Page Down] Move to the previous sheet in the workbook. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Page Up] Select the current and next sheet. To cancel selection of multiple sheets, press [Ctrl] + PAGE DOWN or, to select a different sheet, press [Ctrl] + PAGE UP. .[Shift] + [Ctrl] +[Page Down] Select the current and previous sheet. . . .[Shift] + [Ctrl] + [Page Up] Rename the current sheet (Home, Format, Rename Sheet). . . . . . . . . .[Alt] [H] > [O] > [R] Move or copy the current sheet (Home, Format, Move or Copy Sheet...). . .[Alt] [H] > [O] > [M] Move one cell up, down, left, or right. . . .Arrow Keys Move to the edge of the current data region.(Data region: A range of cells that contains data and that is bounded by empty cells or worksheet borders.). . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + Arrow Key Move to the beginning of the row. . . . . . .[Home] Move to the beginning of the worksheet. [Ctrl] + [Home] Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. . . . . . . . . . . . . . . .[Ctrl] + [End] Move one screen to the right. . . . . . . . . . . .[Alt] + [Page Down] Move one screen to the left. . . . . . . . . . . . .[Alt] + [Page Up] Scroll to display the active cell. . . . . . . . . .[Ctrl] + [Backspace] Display the Go To dialogue box. . . . . . . . . .[Alt] > [H] > [FD] > [G] Display the Find tab of the Find and Replace dialogue box. . . . . . . . . . . . . . . . . . .[Alt] > [H] > [FD] > [F] Display the Replace tab of the Find and Replace dialogue box. . . . . . . . . . . . . . .[Alt] > [H] > [FD] > [R] Moves one cell to the right in a worksheet.Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialogue box. . . . . . . . . . . . . . . .[Tab] Move from top to bottom within the selected range. . . . . . . . . . . . . . . . . . . . . . . . .[Enter] Move from bottom to top within the selected range. . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [Enter] Move from left to right within the selected range. If cells in a single column are selected, move down. . . . . . . .[Tab] Move from right to left within the selected range. If cells in a single column are selected, move up. . . . . . . . . . .[Shift] + [Tab] Move clockwise to the next corner of the selected range. . . . . . . . . . . . . . . . . . . . .[Ctrl] + [.] In nonadjacent selections, switch to the next selection to the right. . . . . . . . . .[Ctrl] + [Alt] + [Right Arrow] Switch to the next nonadjacent selection to the left. . . . . . . . . . . . . . . . . . . .[Ctrl] + [Alt] + [Left Arrow] |
Selections
Select the entire column. . . . . . . . . . . . . . .[Ctrl] + [Space]
Select the entire row. . . . . . . . . . . . . . . . . . .[Shift] + [Space] Selects the entire worksheet. . . . . . . . . . . .[Ctrl] + [A] With multiple cells selected, select only the active cell. . . . . . . . . . . . . . . . . . . . .[Shift] + [Backspace] With an object selected, select all objects on a sheet. . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Space] Alternate between hiding objects, displaying objects, and displaying placeholders for objects. . . . . . . . . . . . . . . .[Ctrl] + [6] Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable report, select the entire PivotTable report. . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [*] Select the array containing the active cell. [Ctrl] + [/] (Array: Used to build single formulae that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) Select all cells that contain comments. . .[Ctrl] + [Shift] + [O] In a selected row, select the cells that don’t match the value in the active cell. .[Ctrl] + [\] In a selected column, select the cells that don’t match the value in the active cell. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [|] Select all cells directly referenced by formulae in the selection. . . . . . . . . . . . . . .[Ctrl] + [[] Select all cells directly or indirectly referenced by formulae in the selection. .[Ctrl] + [Shift] + [{] Select cells that contain formulae that directly reference the active cell. . . .[Ctrl] + []] Select cells that contain formulae that directly or indirectly reference the active cell. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [}] Select the visible cells in the current selection. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Alt] + [;] Add another range of cells to the selection. [Shift] + [F8] Extend the selection by one cell. . . . . . . . .[Shift] + Arrow Key Extend the selection to the last nonblank cell in the same column or row as the active cell. . . . . . . . . . . . . . . .[Ctrl] + [Shift] + Arrow Key Extend the selection to the beginning of the row. . . . . . . . . . . . . . . . . . . . . . . . . . . . .[Shift] + [Home] Extend the selection to the beginning of the worksheet. . . . . . . . . . . . . . . . . . . . . . .[Ctrl] + [Shift] + [Home] Extend the selection to the last used cell on the worksheet (lower-right corner). .[Ctrl] + [Shift] + [End] Extend the selection down one screen. . .[Shift] + [Page Down] Extend the selection up one screen. . . . . .[Shift] + [Page Up] Extend the selection to the last non blank cell in the same column or row as the active cell. . . . . . . . . . . . . . . . .[End] + [Shift] + Arrow Key Extend the selection to the last used cell on the worksheet (lower-right corner). .[End] + [Shift] + [Home] Extend the selection to the last cell in the current row. This key sequence does not work if you have turned on transition navigation keys (Tools menu, Options command, Transition tab). . . . . .[End] + [Shift] + [Enter] Extend the selection to the cell in the upper-left corner of the window. .. . . . . . .[Scroll Lock] + [Shift] + [Home] |