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