63

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)

---