If you have a disability or questions related to accessibility, please contact the for technical assistance. It enables you to quickly get out of the list and continue entering data in other fields on the page. There are also other keyboard shortcuts, and shortcuts that do not use the keyboard at all. Ctrl+W Closes the current workbook. Here are multiple ways to avoid that. Ctrl+P Print the current sheet.
If the cells are blank, move to the last cell in the row or column. Page Up Fn+up Arrow Scroll to display the set rows above the current rows in view. Alt+Shift+F10 displays the menu or message for an Error Checking button. For more information about Quick Entry, see. You can customize Microsoft Word's built-in spelling and grammar checking tools to meet your needs.
Page Down Fn+Down Arrow Go to the next page of the report. If you know the entire key sequence, go ahead and initiate the command. Ctrl+Shift+Page Down selects the current and next sheet in a workbook. Ctrl+End Move to last cell on worksheet. Ctrl+Shift+P Opens the drop-down menu for point size. This is useful for ensuring each cell that should have a formula actually does. Press again to bring it back.
Shift+F11 inserts a new worksheet. Ctrl+Shift+Page Down Select the current and previous sheet in a workbook. Ctrl+F5 restores the window size of the selected workbook window. F11 Creates a chart of the data in the current range. .
Pressing Ctrl+Shift+Spacebar a third time selects the entire worksheet. To fill more than one cell, select the source cell and press Ctrl+Shift+Right to select multiple cells. Using a clipboard manager can expand this functionality greatly! Opens a selected menu press F10 to activate the menu bar or performs the action for a selected command. End also selects the last command on the menu when a menu or submenu is visible. Ctrl+Shift+Home extends the selection of cells to the beginning of the worksheet. For details about keyboard shortcuts for navigating records once you get inside a list, see the next section.
Selects the first command on the menu when a menu or submenu is visible. F3 After a has been created, F3 will names. To provide a better website experience, turbofuture. A box pops up saying you're using an access key from an earlier version of Microsoft Office. Shift+F10 Open a menu of options that are available for selected row. Also clears the content of the active cell.
Shift+Enter completes a cell entry and selects the cell above. 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. Esc Complete an entry in the formula bar and select the cell below. Pressing Alt does the same thing. Ctrl+A or Ctrl+Shift+Spacebar Select the current and next sheet in a workbook.
F3 Displays the Paste Name dialog box. If the worksheet contains data, Ctrl+A selects the current region. Move the focus to commands on the ribbon. Shift+Page Up In a single column, highlights all cells above that are selected. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.