Shortcuts help us save time. It is a little bit irritating to be constantly stopped by the necessity to drag the mouse back and forth the mouse across the menus and ribbons to search for ordinary tasks of inserting tables or often essential actions. Excel 2010 has over 180 shortcut keys for quick navigation. However, not every one of them is helpful. Some of them are intended for very specific applications.
Shortcut Keys |
Action |
F8 |
Extend mode can be turned on or off. EXT shows in the status line, and the arrow keys extend the selection. |
Shift + F8 |
Add another range of cells to the selection or use the arrow keys to move to the beginning of the range we wish to add. |
Shift + arrow key |
Extend the selection by one cell. |
Ctrl + Shift + arrow key |
This shortcut extends the selection to the last non-bank cell in the same column or row as the active cell. |
Shift + Home |
This shortcut will extend the selection to the row's starting. |
Ctrl + Shift + Home |
This shortcut will extend the selection to the worksheet's beginning. |
Ctrl+Shift+End |
This shortcut is used to extend the selection to the worksheet's last utilised cell in the lower-right corner. |
Scroll Lock+Shift+Home |
This shortcut is used to extend the selection to the cell in the window's upper-left corner. |
Scroll Lock+Shift+End |
This shortcut is used to extend the selection to the cell in the window's lower-left corner. |
Shift + Page Down |
Using this shortcut, we can extend the selection down to one screen. |
Shift + Page Up |
Using this shortcut, we can extend the selection up one screen. |
End+Shift+Home |
This shortcut is used to extend the selection to the worksheet's last utilised cell in the lower-right corner. |
End+Shift+Enter |
This shortcut is used to extend the selection to the last cell in the current row. |
The following are the shortcut keys which we used for data entry, formatting, and calculating data:
Shortcut Keys |
Actions |
Enter |
Complete a cell entry and select the next cell below. |
Alt + Enter |
Using this shortcut, we can start a new line in the same cell. |
Ctrl + Enter |
Using this shortcut, we can fill the selected cell range with the present entry. |
Shift + Enter |
Using this shortcut, we can select the next cell above after completing a cell entry. |
Tab |
Complete a cell entry and select the next cell to the right. |
Shift+Tab |
Complete a cell entry and select the previous cell to the left. |
Esc |
We can use this to cancel a cell entry. |
Home |
Move to the line's starting. |
F4 or Ctrl+Y |
Repeat the last action. |
Arrow keys |
Move one character left, right, up, or down |
Ctrl+Shift+F3 |
Creates names from row and column labels. |
Ctrl+ D |
Fill down |
Ctrl + R |
Fill to the right. |
Ctrl+ F3 |
We used this shortcut to define a name. |
Ctrl + K |
Using this shortcut, we can insert a hyperlink. |
Ctrl+shift+ : (colon) |
Enter the time. |
Ctrl+ ; (semicolon) |
Enter the date. |
Alt+down arrow |
This shortcut will show a drop-down list of the values in the current column of a range. |
Ctrl+Z |
Undo the last action. |
= (equal sign) |
Start a formula |
Ctrl+Z |
Undo the last action. |
Backspace |
Delete one character to the left in the formula bar. |
Enter |
Complete a cell entry from the cell or formula bar. |
Ctrl+Shift+Enter |
Enter a formula as an array formula. |
Esc |
Cancel an entry in the cell or formula bar. |
Shift+F3 |
Show the Insert Function dialog box in a formula. |
Ctrl + A |
This shortcut will show the function Argument dialog box when the insertion point is to the right of a function name in a formula. |
Ctrl+Shift+A |
Insert the argument names and parentheses when the insertion point is to the right of a function name in a formula. |
F3 |
This will paste a defined name into a formula. |
Alt+=(equal sign) |
This shortcut will insert an AutoSum formula with the SUM function. |
Ctrl+Shift+"(+quotation mark) |
In the cell or the formula bar, copy the value from the cell above the active cell. |
Ctrl+'(apostrophe) |
In the cell or the formula bar, copy a formula from the cell above the active cell. |
Ctrl+' (backtick) |
Alternate between showing cell values and showing formulas. |
F9 |
Calculate all worksheets in all workbooks that are open. When a portion of formula is selected, calculate the selected portion and press Enter or Ctrl+Shift+Enter (for array formulas) to replace the selected portion with the calculated value. |
Shift+F9 |
Using this shortcut, we can calculate the active worksheet. |
Ctrl+Alt+F9 |
Calculate all worksheets in all open workbooks, whether or not they have changed since the previous calculation. |
Ctrl+Alt+Shift+F9 |
Recheck dependent formulas and then calculate the cells in all open workbooks, even those not marked as computed. |
F2 |
Edit the active cell and position the insertion point at the end of the cell contents. |
Alt + Enter |
Using this shortcut, we can start a new line in the same cell. |
Backspace |
Edit the active cell and then clear it or delete the preceding character in the active cell as we edit cell contents. |
Delete |
Delete the character to the right of the insertion point or delete the selection. |
Ctrl+Delete |
With the help of this shortcut, we can delete text to the end of the line. |
F7 |
Show the spelling dialog box. |
Shift+F2 |
With the help of this shortcut, we can edit a cell comment. |
Enter |
Complete a cell entry and select the next cell below. |
Ctrl+Z |
This shortcut will help you to undo the last action. |
Ctrl+Shift+Z |
When the Autocorrect, smart tag appears then undo or redo the last automatic correction. |
Delete |
Clear the content of the selected cells. |
Ctrl+ -(hypen) |
This shortcut will delete the selected cells. |
Ctrl+Shift++(plus sign) |
This shortcut will insert the blank cells. |
Alt+' (apostrophe) |
This shortcut will display the style dialog box. |
Ctrl+1 |
Display the Format cells dialog box. |
Ctrl+Shift+~ |
Apply the General number format. |
Ctrl+Shift+% |
This shortcut will apply the percentage format without decimal places. |
Ctrl+Shif+^ |
This shortcut will apply the exponential number format with two decimal places. |
Ctrl+Shift+# |
Using this shortcut, we can apply the date format with the day, month, and year. |
Ctrl+Shift+@ |
Using this shortcut, we can apply the time format with the hour and minute and AM or PM. |
Ctrl+Shift+! |
Using this shortcut, we can apply the Number format with two decimal places, thousands, separator, and minus sign (-) for negative values. |
Ctrl+B |
With this shortcut, we can apply or remove the bold formatting. |
Ctrl+U |
With this shortcut, we can apply or remove the underline. |
Ctrl+I |
With this shortcut, we can apply or remove the italic formatting. |
Ctrl+5 |
This shortcut is used to apply or remove the strikethrough. |
Ctrl+9 |
This shortcut is used to hide the selected rows. |
Ctrl+Shift+( (opening parenthesis) |
Unhide any hidden rows within the selection. |
Ctrl+0 (zero) |
Hide the selected columns. |
Ctrl+Shift+) (closing parenthesis) |
Unhide any hidden columns within the selection |
Ctrl+Shift+& |
Using this shortcut, we can apply the outline border to the selected cells. |
Ctrl+Shift+_(underscore) |
Using this shortcut, we can remove the outline border from the selected cells. |
Shortcut Key |
Action |
Ctrl+spacebar |
Select the complete column if we used this outside a table. Toggle between selecting the data, data, and headers, and the whole column if used inside a table. |
Shift+spacebar |
Select the complete row. Toggle between selecting the table row and the complete row if we are inside a table. |
Shift+backspace |
Revert selection to only the active cell if numerous cells are selected. |
Ctrl+Shift+* |
Select the current region. |
Ctrl+/ |
Select the array containing the active cell. |
Ctrl+Shift+O(letter O) |
Select the cells which contain comments. |
Ctrl+\ |
In a selected column, select the cells that don't match the current cell's value. |
Ctrl+{ (opening square bracket) |
Select all cells that are directly or indirectly referenced by formulas in the selection. |
Ctrl+] (closing square bracket) |
Select cells which comprise formulas that directly reference the active cell. |
Ctrl+Shift+} (closing brace) |
Select cells which comprise formulas which directly or indirectly reference the active cell. |
Alt+ ; (semicolon) |
This shortcut will select the visible cells in the current selection. |