Shortcut Keys in Excel 2010
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 for Navigation
The following are the shortcut keys for navigation:
| Shortcut Key | Action |
|---|---|
| Ctrl + Home | Move to Cell A1. |
| Shift + F11 | New Worksheet |
| Ctrl + End | This shortcut will move to the last cell in the used range of the worksheet. |
| Ctrl + Page Up | Using this shortcut, we can move to the previous worksheet. |
| Ctrl + Page + Down | With the help of this shortcut, we can move to the next worksheet. |
| Alt + Tab | Using this shortcut, we can switch to the next program. |
| Alt + Shift + Tab | Using this shortcut, we can switch to the previous program. |
| Home | Move to the begin of the row. |
| Ctrl + Esc | This shortcut will display the Windows start menu. |
| Ctrl + F | Restore window size of current workbook. |
| F6 | Switch to the next pane in a Window that has been split. |
| Ctrl + F6 | This shortcut will switch to the next, open the worksheet window if we have more than one open workbook window. |
| Ctrl + Shift + F6 | We can return to the previous workbook window by using this shortcut. |
| Ctrl + F9 | Minimize the window. |
| Ctrl + F10 | Maximize the window. |
| Ctrl + .(period) | This shortcut will take you to the next corner of the range you’ve chosen. |
| Ctrl + Backspace | Scroll to display the active cell. |
| F5 | Show the GoTO dialog. |
| Shift + F5 | Show the Find dialog |
| Shift + F4 | Find next. |
Shortcut Keys for Extending Selection
The following are the shortcut keys for extending selection:
| 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. |
Shortcut Keys for Borders
The following are the shortcut keys that we used for border:
| Shortcut Key | Action |
|---|---|
| Alt + B | We used this shortcut to apply or remove the bottom border. |
| Alt + T | This shortcut is used to remove the top border. |
| Alt + R | Using this shortcut, we can remove the right border. |
| Alt + L | Using this shortcut, we can remove the left border. |
| Alt + H | If cells in several rows are chosen, then apply or remove the horizontal divider using this shortcut. |
| Alt + V | If a cell in several rows is chosen, then apply or remove the vertical divider. |
| Alt + U | With the help of this shortcut, we can apply or remove the diagonal border. |
| Alt + D | With the help of this shortcut, we can apply or remove the downward diagonal border. |
Shortcut Keys for Data Entry, Formatting, and Calculating Data
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. |
| [email protected] | 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 Keys for Selecting Data and Cells
The following are the shortcut keys for selecting data and 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. |
Shortcut Keys for Excel Ribbon
The following are some shortcut keys for Excel Ribbon:
| Shortcut Key | Actions |
|---|---|
| Ctrl+F1 | Using this shortcut, we can minimize or restore the Ribbon. |
| Shift+F10 | This shortcut will show you the shortcut menu for the selected command. |
| Alt/F10 | This shortcut will select the Ribbon’s active tab and activate the access keys. In order to return to the document and cancel the access keys, press either of these keys again. Then use the left or right arrows to move left or right. |
| Space/Enter | Using this shortcut, we are able to active the selected command or control in the Ribbon, and select the desired menu or gallery. |
| Enter | Finish changing a value in control in the Ribbon, move focus back to the document. |
| F1 | Get information about the command or control we have selected in the Ribbon. (If the selected command has no help topic associated with it, the Help table of content for that program is displayed instead) |
Next TopicAdvanced Formulas in Excel
