Excel Keyboard Shortcuts

Excel keyboard shortcuts help increasing productivity of working in Excel by reducing time taken to performs various actions.

Shortcuts for Selecting Data and Cells
Select entire column.Press : Ctrl+Spacebar
Select entire row.Press : Shift+Spacebar
Select entire worksheet.Press : Ctrl + A
With multiple cells selected, select only active cell.Press : Shift+Backspace
Hide /display objects,display place-holders.Press : Ctrl+6
Shortcuts for Extending Selection
Turn extend mode on or off.Press : F8
Add another range of cells to the selection.Press : Shift+F8
Extend selection by one cell.Press : Shift+Arrow Key
Extend selection to last non-blank cell in same column or row as the active cell.Press : Ctrl+Shift+Arrow key
Extend selection to the beginning of the row.Press : Shift+Home
Extend selection to the beginning of the worksheet.Press : Ctrl+Shift+Home
Extend selection to last used cell on the worksheet.Press : Ctrl+Shift+End
Extend selection down one screen.Press : Shift+Page Down
Extend selection up one screen.Press : Shift+Page Up
Extend selection to last non-blank cell in same column or row as the active cell.Press : End+Shift+Arrow key
Extend selection to the last used cell on the worksheet.Press : End+Shift+Home
Shortcuts for Entering Data in Cells
Complete a cell entry and select the cell below.Press : Enter
Start a new line in the same cell.Press : Alt+Enter
Fill the selected cell range with the current entry.Press : Ctrl+Enter
Complete a cell entry and select the previous cell above.Press : Shift+Enter
Complete a cell entry and select the next cell to the right.Press : Tab
Complete a cell entry and select the previous cell to the left.Press : Shift+Tab
Cancel a cell entry.Press : ESC
Move one character up, down, left, or right.Press : Arrow keys
Move to the beginning of the line.Press : Home
Repeat the last action.Press : F4 or Ctrl+Y
Create name for a cell.Press : Ctrl+Shift+F3
Fill down.Press : Ctrl+D
Fill to the right.Press : Ctrl+R
Define a name.Press : Ctrl+F3
Insert a hyperlink.Press : Ctrl+K
Enter the time.Press : Ctrl+Shift+: (colon)
Display a drop-down list of the values in the current column of a range.Press : Alt+Down Arrow
Undo the last action.Press : Ctrl+Z
Shortcuts for Formulas
Start a formulaPress :=(equal sign)
Move the insertion point into the Formula Bar when editing in a cell is turned off.Press : F2
In Formula Bar, Delete one character to the left.Press : Backspace
Cancel an entry in the cell or Formula Bar.Press : ESC
In a formula, display the Insert Function dialog box.Press : Shift+F3
When insertion point is to right of a function name in a formula, display Function Arguments dialog box.Press : Ctrl+A
Insert an AutoSum formula with the SUM function.Press : Alt +=(equal sign)
Copy the value from the cell above the active cell into the cell or the Formula Bar.Press : Ctrl+Shift+ (quotation mark)
Copy a formula from the cell above the active cell into the cell or the Formula Bar.Press : Ctrl+' (apostrophe)
Alternate between displaying cell values and displaying formulas.Press : Ctrl+` (single left quotation mark)
Calculate all worksheets in all open workbooks.Press : F9
Shortcuts for Editing Data
Edit the active cell and position the insertion point at the end of the cell contents.Press : F2
Start a new line in the same cell.Press : Alt+Enter
Edit the active cell and then clear it, or Delete the preceding character in the active cell as you edit cell contents.Press : Backspace
Delete the character to the right of the insertion point, or Delete the selection.Press : Delete
Delete text to the end of the line.Press : Ctrl+Delete
Display the Spelling dialog box.Press : F7
Edit a cell comment.Press : Shift+F2
Complete a cell entry and select the next cell below.Press : Enter
Undo the last action.Press : Ctrl+Z
Cancel a cell entry.Press : ESC
When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.Press : Ctrl+Shift+Z
Shortcuts for Inserting, Deleting or Copying Cells
Copy the selected cells.Press : Ctrl+C
Display the Microsoft Office Clipboard (multiple copy and paste).Press : Ctrl+C, followed by another Ctrl+C
Cut the selected cells.Press : Ctrl+X
Paste copied or cut cells.Press : Ctrl+V
Clear the contents of the selected cells.Press : Delete
Delete the selected cells.Press : Ctrl+Hyphen
Insert blank cells.Press : Ctrl+Shift+Plus Sign
Shortcuts for Formatting Data
Display the Style dialog box.Press : Alt+' (apostrophe)
Display the Format Cells dialog box.Press : Press : Ctrl+1
Apply the General number format.Press : Ctrl+Shift+~
Apply Currency format with two decimal places (-ve numbers in parentheses).Press : Ctrl+Shift+$
Apply Percentage format with no decimal places.Press : Ctrl+Shift+%
Apply Exponential number format with two decimal places.Press : Ctrl+Shift+^
Apply Date format with the day, month, and year.Press : Ctrl+Shift+#
Apply Time format with the hour and minute, and AM or PM.Press : Ctrl+Shift+@
onclick=vh('k107');>Apply Number format with two decimal places, thousands separator, and minus sign (-)for -ve values.Press : Ctrl+Shift+!
Apply or remove bold formatting.Press : Ctrl+B
Apply or remove italic formatting.Press : Ctrl+I
Apply or remove underling.Press : Ctrl+U
Apply or remove strikethrough.Press : Ctrl+5
Hide the selected rows.Press : Ctrl+9
Unhide any hidden rows within the selection.Press : Ctrl+Shift+((opening parenthesis)
Hide the selected columns.Press : Ctrl+0 (zero)
Unhide any hidden columns within the selection.Press : Ctrl+Shift+)(closing parenthesis)
Apply the outline border to the selected cells.Press : Ctrl+Shift+&
Remove the outline border from the selected cells.Press : Ctrl+Shift+_
Shortcuts for Working with Worksheets
Insert a new worksheet.Press : Shift+F11 or Alt+Shift+F1
Move to the next sheet in the workbook.Press : Ctrl+Page Down
Move to the previous sheet in the workbookPress : Ctrl+Page Up
Select the current and next sheet.Press : Shift+Ctrl+Page Down
Cancel selection of multiple sheets.Press : Ctrl+Page Down
Select the current and previous sheet.Press : Shift+Ctrl+Page Up
Rename the current sheet.Press : Alt+O, H, R
Move or copy the current sheet.Press : Alt+E, M
Delete the current sheet.Press : Alt+E, L
Shortcuts for Moving and Scrolling
Move one cell up, down, left, or right.Press : Arrow keys
Move one cell to the right.Press : Tab
Move one cell to the left.Press : Shift+Tab
Move to the edge of the current data region.Press : Ctrl+Arrow key
Move to the beginning of the row.Press : Home
Move to the beginning of the worksheet.Press : Ctrl+Home
Move to the last cell on the worksheet.Press : Ctrl+End
Move down one screen.Press : Page Down
Move up one screen.Page Up
Move one screen to the right.Press : Alt+Page Down
Move one screen to the left.Press : Alt+Page Up
Switch to the next pane in a worksheet that has been split.Press : F6
Scroll to display the active cell.Press : Ctrl+Backspace
Display the Go To dialog box.Press : F5
Display the Find dialog box.Press : Shift+F5
Repeat the last Find action.Press : Shift+F4
Move between unlocked cells on a protected worksheet.Press : Tab
Shortcuts for Moving within a Selected Range
Move from top to bottom within the selected range.Press : Enter
Move from bottom to top within the selected range.Press : Shift+Enter
Move from left to right within the selected range.Press : Tab
Move from right to left within the selected range.Press : Shift+Tab
Move clockwise to the next corner of the selected range.Press : Ctrl+PERIOD
In nonadjacent selections, switch to the next selection to the right.Press : Ctrl+Alt+Right Arrow
Switch to the next non-adjacent selection to the left.Press : Ctrl+Alt+Left Arrow
Shortcuts for Displaying and Using Windows
Switch to the next program.Press : Alt+Tab
Switch to the previous program.Press : Alt+Shift+Tab
Display the Windows Start menu.Press : Ctrl+ESC
Close the selected workbook window.Press : Ctrl+W or Ctrl+F4
Restore the window size of the selected workbook window.Press : Ctrl+F5
Minimize a workbook window to an icon.Press : Ctrl+F9
Maximize or restore the selected workbook window.Press : Ctrl+F10
Copy a picture of the screen to the Clipboard.Press : Print Screen
Copy a picture of the selected window to the Clipboard.Press : Alt+Print Screen
Shortcut for Print and Print Preview
Display Print dialog box.Press : Ctrl+P or Ctrl+Shift+F12
Modified : Jan 24, 2019