Excel Keyboard Shortcuts

Excel keyboard shortcuts help in 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 underlining.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