Here we discuss the working of Excel Keyboard Shortcuts, how to access them and how to use Excel Keyboard Shortcuts to save your time. This is a guide to Excel Keyboard Shortcuts. Move to the edge of the current data region in a worksheet. Move one screen to the left in a worksheet. Redo the last undone action: CTRL and Z: Undoes the last action. Move one screen to the right in a worksheet. Move to the previous sheet in a workbook. After selecting the 'Options', Excel displays the 'Excel Options' window. Excel Keyboard Shortcuts also helps out or reduces the usage of the mouse & and its number of clicks.Īpart from these, the most commonly used shortcut keys are: In case the redo shortcut is not present on Quick Access Toolbar, we must add it manually by using the following steps: First, we need to navigate the File tab and select the 'Options' from the File menu list.Excel Keyboard Shortcuts helps you to provide an easier and usually quicker method of directing and finishing commands.Things to Remember About Excel Keyboard Shortcuts Many of the most common keyboard shortcuts that we use appear to be on the left side of the keyboard: Copy Ctrl + C. It Activates the Microsoft Script Editor window.Ĩ. ALT + Letter Keys Shortcut Shortcut Keyĭisplays the Remove Duplicates dialog boxįormat Cells dialog box with the Number tab selected.įormat Cells dialog box with the Font tab selected.įormat number with a thousand’s comma (,) separatorĮxpand the Insert Form Controls and ActiveX Controls drop-down menuĪdd or Remove the vertical interior border. It Displays the drop-down menu for the corresponding smart tag. Inserts a new worksheet into the active workbook Insert Chart (It Creates a chart of the data in the current range)ħ. ALT + SHIFT + Function Keys Shortcut Shortcut Key Maximize or restore currently selected workbook windowĥ. SHIFT + Function Keys Shortcut Shortcut Keyĭisplays formula box to Paste function into the formulaĦ. ALT + Function Keys Shortcut Shortcut Key Minimize currently selected workbook window Tip To keep this reference available when you work, you may want to print this topic. This includes the shortcuts that you can use to access the ribbon. It will Unhide the rows in the current selectionĤ. CTRL + Function Keys Shortcut Shortcut Keyĭisplay Print Preview area on Print tab of Backstage ViewĪlternate between the currently active workbook window and the next workbook windowĪpply Move command on the active workbook windowĪpply Resize command on the active workbook window Excel keyboard shortcuts and function keys This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel 2016 for Windows.
Ctrl + A is also under the Formulas and Functions category.
Excel keyboard shortcut for redo series#
It Selects the current region (associated by blank rows and columns) (1) When in a cell, select data area around active cell (press shortcut a second or third time to select entire worksheet) or select entire worksheet or (2) When an object is selected, select all such objects in worksheet. Function keys are a series of keys on your keyboard that perform specific operations when pressed together with other keys. It Enters the value from the cell directly above into the active cell It Unhides the columns in the current selection. It is also used to switch between absolute/relative refs