Excel keyboard shortcuts help increasing productivity of working in Excel by reducing time taken to performs various actions.
| 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 |
| 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 |
| 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 |
| Start a formula | Press :=(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 |
| 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 |
| 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 |
| 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+_ |
| 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 workbook | Press : 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 |
| 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 |
| 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 |
| Display Print dialog box. | Press : Ctrl+P or Ctrl+Shift+F12 |