MS-Excel Shortcut Keys
In this topic we will show you most useful MS-Excel Shortcut Keys, for example Ctrl + Drag, Shift + Drag, Shift + Drag and more Shortcut Keys we will consider in this topic.
| Shortcut | Description | |
|---|---|---|
| Ctrl + Drag | Drag and copy or Drag to duplicate worksheet | |
| Ctrl + Shift + Drag | Drag and insert copy | |
| Shift + Drag | Drag and insert | |
| Alt + Drag | Drag to worksheet | |
| Drag | Drag and cut | |
MS-Excel Shortcut Keys
| Shortcut | Description | |
|---|---|---|
| Ctrl + D | Fill down from cell above | |
| Ctrl + E | Flash fill | |
| Ctrl + K | Add hyperlink | |
| Ctrl + Shift + “ | Copy value from cell above | |
Extend Selection
| Shortcut | Description | |
|---|---|---|
| Ctrl + Shift + Down Arrow | Extend the selection to the last cell down | |
| Ctrl + Shift + Left Arrow | Extend the selection to the last cell left | |
| Ctrl + Shift + Right Arrow | Extend the selection to the last cell right | |
| Ctrl + Shift + Up Arrow | Extend the selection to the last cell up | |
| Shift + Down Arrow | Extend selection by one cell down | |
| Shift + Left Arrow | Extend selection by one cell left | |
| Shift + Right Arrow | Extend selection by one cell right | |
| Shift + Up Arrow | Extend selection by one cell up | |
| Alt + Shift + Page Down | Extend selection right one screen | |
| Alt + Shift + Page Up | Extend selection left one screen | |
File
| Shortcut | Description | |
|---|---|---|
| Ctrl + F4 | Close current workbook | |
| Ctrl + P | Print file | |
| Alt + F4 | Close Excel | |
Formatting
| Shortcut | Description | |
|---|---|---|
| Ctrl + 5 | Apply or remove strikethrough formatting | |
| Ctrl + B | Apply or remove bold formatting | |
| Ctrl + I | Apply or remove italic formatting | |
| Ctrl + U | Apply or remove underscoring | |
| Ctrl + Shift + F | Display Format Cells with Font tab selected | |
| Alt + H,5 | Remove indent | |
| Alt + H,6 | Indent | |
| Alt + H,A,C | Align center | |
| Alt + H,FG | Increase font size one step | |
| Alt + H,FK | Decrease font size one step | |
| Alt + H,A,L | Align left | |
| Alt + H,A,R | Align right | |
General
| Shortcut | Description | |
|---|---|---|
| Ctrl + F | Display find and replace | |
| Ctrl + H | Display find and replace, replace selected | |
| Ctrl + V | Paste content from clipboard | |
| Ctrl + X | Cut selected cells | |
| Ctrl + Y | Redo last action | |
| Ctrl + Shift + F4 | Find previous match | |
| Ctrl + Alt + V | Display the Paste Special dialog box | |
| Shift + F4 | Find next match | |
| Alt + F,T | Open options | |
Grid Operations
| Shortcut | Description | |
|---|---|---|
| Ctrl + 8 | Hide or show outline symbols | |
| Ctrl + Alt + + | Zoom in | |
| Ctrl + Alt + - | Zoom out | |
| Alt + Shift + Right Arrow | Group rows or columns | |
| Delete | Delete contents of selected cells | |
Navigation
| Shortcut | Description | |
|---|---|---|
| Ctrl + Left Arrow | Move to left edge of data region | |
| Ctrl + Right Arrow | Move to right edge of data region | |
| Left Arrow | Move one cell left | |
| Right Arrow | Move one cell right | |
| End | Turn end mode on | |
Ribbon
| Shortcut | Description | |
|---|---|---|
| F1 | Get help on selected control or Open help | |
| Ctrl + F1 | Expand or collapse ribbon | |
| Alt | Activate access keys | |
| Spacebar | Activate or open selected control | |
Selection
| Shortcut | Description | |
|---|---|---|
| Ctrl + Click | Add non-adjacent cells to selection | |
| Ctrl + Alt + Left Arrow | Move left between non-adjacent selections | |
| Ctrl + Alt + Right Arrow | Move right between non-adjacent selections | |
| Shift + Click | Add adjacent cells to selection | |
Tables and Filters
| Shortcut | Description | |
|---|---|---|
| Ctrl + T | Insert table | |
| Ctrl + Shift + L | Toggle Autofilter | |
| Ctrl + Shift + T | Toggle table total row | |
| Alt + C | Clear slicer filter | |
| Alt + Down Arrow | Activate filter | |
Selecting Cells, Rows, and Column
| Shortcut | Description | |
|---|---|---|
| F8 | Toggle Extend mode on and off |  |
| Shift + Backspace | Reduce the selection to the active cell | |
| Shift + Home | Extend the selection to the first cell in the row | |
| Shift + Page Up | Extend the selection upward by one screen | |
| Shift + Page Down | Extend the selection downward by one screen | |
| Shift + F8 | Toggle add mode on and off | |
| Ctrl + Shift + Home | Extend the selection to the first cell used on the worksheet |  |
| Ctrl + Shift + End | Extend the selection to the last cell used on the worksheet | |
| Ctrl + Shift + Spacebar | Select all the objects on the current worksheet while retaining the current selection | |
| Ctrl + Spacebar | Extend the selection in the direction of the arrow key | |
| Ctrl + A | Select all cells on the current worksheet | |
| Shift + Spacebar | Select the current columns | |
Applying Border
| Shortcut | Description | |
|---|---|---|
| Ctrl + Shift + & | Apply an outline border | |
| Ctrl + Shift + _ | Remove the outline border | |
| Alt + B | Toggle the bottom border on the selected cells | |
| Alt + D | Toggle the downward diagonal border on the selected cells | |
| Alt + H | Toggle the horizontal border on the selected cells | |
| Alt + L | Toggle the left border on the selected cells | |
| Alt + R | Toggle the right border on the selected cells | |
| Alt + T | Toggle the top border on the selected cell | |
| Alt + U | Toggle the upward diagonal border on the selected cells | |
| Alt + V | Toggle the vertical border on the selected cells | |
Creating and Navigating
| Shortcut | Description | |
|---|---|---|
| F11, Alt + F1 | Create a chart from the selected range | |
| Shortcut | Description | |
|---|---|---|
| F2 | Switch the active cell into Edit mode | |
| F3 | Pastes a defined name into a formula | |
| F4 | Repeats the last command or action, if possible | |
| F7 | Displays the Spelling dialog box to checkspelling in the active worksheet or selected range | |
| F8 | Toggle Extend mode on and off | |
| F10 | Minimizes a workbook window to an icon | |
| F12 | Displays the Save As dialog box | |
| Ctrl + F3 | Display the Define Name dialog box | |
| Ctrl + F5 | Restores the window size of the selected workbook window | |
| Ctrl + F9 | Minimize the active workbook window |  |
| Ctrl + F10 | Restore or maximize the selected minimized workbook window | |
| Ctrl + 0 | Hides the selected columns | |
| Ctrl + 9 | Hides the selected rows | |
| Ctrl + A | Selects the current region | |
| Ctrl + C | Displays the Microsoft Office Clipboard | |
| Ctrl+ G | Display the Go To dialog box | |
| Ctrl + O | Displays the Open dialog box to open or find a file | |
| Ctrl + R | Displays the Print dialog box | |
| Ctrl + S | Saves the active file with its current file name and location | |
| Ctrl + Z | Repeats the last command or action, if possible | |
| Ctrl + Backspace | Scroll the workbook to display the active cell | |
| Ctrl + Spacebar | Select the current worksheet | |
| Ctrl + Home | Move to the last used cell in the worksheet | |
| Ctrl + End | Move to the last used cell in the worksheet | |
| Ctrl + Enter | Fill the selected range with the entry | |
| Ctrl + Delete | Delete from the insertion point to the end of the cell's contents. | |
| Ctrl + Down Arrow | Display the AutoComplete drop-down list | |
| Ctrl + _ | Removes the outline border from the selected cells | |
| Ctrl + ; | Enters the current date | |
| Ctrl + : | Enters the current time | |
| Ctrl + Shift + F3 | Display the Create Names dialog box | |
| Ctrl + Shift + O | Selects all cells that contain comments | |
| Ctrl + Shift + Z | Undo the most recent AutoCorrect | |
| Ctrl + Shift + : | Enter the time in the active cell | |
| Shift + F2 | Insert a new comment or edit the existing comment | |
| Shift + F8 | Toggle add mode on and off | |
| Shift + F10 | Displays the shortcut menu for a selected item | |
| Shift + F11 | Inserts a new worksheet | |
| Shift + Enter | Enter the entry in the cell and select the next cell in the opposite direction | |
| Shift + Tab | Enter the entry in the cell and select the next cell to the left. | |
| Shift + Spacebar | Select the current row | |
| Alt + F8 | Displays the Macro dialog box to run, edit, or delete a macro | |
| Alt + Enter | Begin a new line within the active cell | |
| Alt + Page Up | Move to the left by one screen | |
| Alt + Shift + F1 | Inserts a new worksheet | |
| Enter | Enter the entry in the cell and select the next cell | |
| Esc | Cancel editing in the active cell | |
| Tab | Enter the entry in the cell and select the next cell to the right | |
| Backspace | Delete from the insertion point to the end of the cell's contents | |
| Home | Move to the first cell in the active row | |
| Page Down | Move down the screen | |
| Page Up | Move up the screen | |
Formatting Cells
| Shortcut | Description | |
|---|---|---|
| Ctrl + 1 | Display the Format Cells dialog box | |
| Ctrl + 5 | Toggle strikethrough | |
| Ctrl + Shift + ~ | Apply the General format | |
| Ctrl + Shift + $ | Apply the two-decimal-place Currency format | |
| Ctrl + Shift + % | Apply the Percentage format ( no decimal places) | |
| Ctrl + Shift + ^ | Apply the Exponential format with two decimal places | |
| Ctrl + Shift + # | Apply the DD-MM-YY date format | |
| Ctrl + Shift + @ | Apply the HH:MM AM/PM time format | |
| Ctrl + Shift + ! | Apply the two-decimal-place number format with the thousands separator | |
| Alt + ' | Display the Style dialog box | |
Hiding and Unhiding Rows and Columns
| Shortcut | Description | |
|---|---|---|
| Ctrl + 0 | Hide all selected columns | |
| Ctrl + 9 | Hide all selected rows | |
| Ctrl + Shift + { | Unhide hidden rows in the selection | |
| Ctrl + Shift + } | Unhide hidden columns in the selection | |
Inserting and Deleting Cells
| Shortcut | Description | |
|---|---|---|
| Ctrl + - | Delete the selected cells | |
| Ctrl + Shift + + | Insert cells | |
Minimizing and Navigating
| Shortcut | Description | |
|---|---|---|
| Ctrl + F9 | Minimize the active workbook window | |
| Page Down | Move down one screen | |
| Alt + Page Down | Move to the right by one screen | |
| Alt + Page Up | Move to the left by one screen | |
| Shift + F11, Alt + Shift + F1 | Insert a new worksheet in the active workbook | |
| Ctrl + Shift + Page Down | Select the current worksheet and the next worksheet | |
| Ctrl + Shift + Tab | Select the previous minimized workbook window | |
| Ctrl + End | Move to the first cell in the worksheet | |
| Ctrl + Home | Move to the last used cell in the worksheet | |
| Ctrl + Backspace | Scroll the workbook to display the active cell | |
| Ctrl + Tab | Select the next minimized workbook window | |
| Ctrl + Page Up | Move to the next worksheet | |
| Ctrl + N | Create a new default workbook | |
| Ctrl + G | Display the Go To dialog box | |
| Ctrl + F10 | Restore or maximize the selected minimized workbook window | |
| Page Up | Move up one screen | |
Recalculating Worksheets
| Shortcut | Description | |
|---|---|---|
| F9 | Recalculating all the worksheets in all the open workbooks | |
| Ctrl + Alt + F9 | Recalculating all calculations in all the worksheets in all the open workbooks | |
| Ctrl + Alt + Shift + F9 | Recheck all formulas, then recalculate all calculation in all the worksheets | |
Selecting Cells That Match
| Shortcut | Description | |
|---|---|---|
| Ctrl + / | Select the array that the active cell is in | |
| Ctrl + Shift + 0 | Select all cells that have comments attached | |
| Ctrl + Shift + | | Select non-matching cells in the active column | |
| Ctrl + Shift + * | Select the data region | |
| Ctrl + Shift + } | Select cells that contain formulas directly or indirectly referencing the active cell | |
| Ctrl + Shift + { | Select cells directly or indirectly referenced by formulas in the active cell | |
| Ctrl + ] | Select cells that contain formulas directly referencing the active cell | |
| Ctrl + [ | Select cells directly referenced by formulas in the active cell. | |
| Ctrl + \ | Select non-matching cells in the active row | |
| Alt + ; | Select only the visible cells in the current selection | |
Working in Data Forms
| Shortcut | Description | |
|---|---|---|
| Ctrl + Page Down | Insert a new, blank record in the database | |
| Shift + Enter | Move to the next record, first field | |
| Down Arrow | Move to the next record, same field | |
| Up Arrow | Move to the previous record, same field | |
| Page Down | Move ten records backward, same field | |
| Page Up | Move ten records backward, same field | |
| Enter | Move to the next record, first field | |
Working in PivotTables
| Shortcut | Description | |
|---|---|---|
| Ctrl + Shift + * | Select the entire Pivot Tables | |
| Alt + Shift + Left Arrow | Group the select items | |
Working in Print Preview
| Shortcut | Description | |
|---|---|---|
| Ctrl + Up Arrow | Display the first page of the print area | |
| Ctrl + Down Arrow | Display the last page of the print area | |
| Page Up | Display the previous page | |
| Page Down | Display the next page | |
Working with Formulas
| Shortcut | Description | |
|---|---|---|
| F3 | Displays the Paste Name dialog box | |
| Ctrl + A | Display the Function Arguments dialog box | |
| Ctrl + ' | Copy the formula from the cell above the active cell | |
| Ctrl + Shift + A | Enter the argument names in the Formula bar | |
| Ctrl + Shift + Enter | Enter the formula as an array formula | |
| Ctrl + Shift + \ | Copy the value of the cell above the active cell | |
| Shift + F3 | Display the Insert Function dialog box | |
| Alt + = | Insert an AutoSum formula in the active cell | |
| Enter | Enter the formula in the cell | |
| = | Start creating a formula | |
0 Comments