Javatpoint Logo
Javatpoint Logo

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)






Youtube For Videos Join Our Youtube Channel: Join Now

Feedback


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA