Keyboard access to the ribbonThis article describes what Key Tips and how you can use it to access the tape. It also lists the CTRL key combination shortcut keys, locks, and some other common shortcut keys in Microsoft Excel.
Note If you use Microsoft Excel Starter 2010, be aware that not all of the properties listed in Excel are supported in Excel Starter 2010.
Keyboard access to the ribbon
If you are a new band, this section can help you understand the band model of keyboard shortcuts. This is gonna be the new keyboard shortcuts, called Key Tips. For tips button appears, press ALT.
Tab strip displays, press the Tab key, for example, by pressing the letter N on the Insert tab, or M Formulas tab. This makes all the Key Tip badges, button tab. Then press the desired key.Seeing the old shortcuts still work?
Keyboard shortcuts that begin with CTRL are still in Excel 2010. For example, CTRL + C still copies to the clipboard, and CTRL + V to paste from the clipboard yet.
Most of the old ALT + shortcut still works well. However, you will need to know the full shortcut from memory - no reminders of what letters to press the screen. Try, for example, press ALT and then some old menu keys E (Edit), V (View), I (More), and so on. Pops up saying you use the key to access previous versions of Microsoft Office. If you know the size of a key combination, go ahead and start commands. If you do not know the sequence, press ESC and use the key tip badge instead.
CTRL combination shortcut keys
Button DescriptionCTRL + PgUp Switches between worksheet tabs, from left to right.CTRL + Page Down Switches between worksheet tabs on the right-to-left.CTRL + SHIFT + (Display hidden rows within the selection.CTRL + SHIFT + & Applies the outline border to the selected cells.CTRL + SHIFT_ Removing the border line of the selected cells.CTRL + SHIFT + ~ on the general number format.CTRL + SHIFT + $ Currency format with two decimal places (negative numbers in parentheses).CTRL + SHIFT +% Applicable Percentage format with no decimal.CTRL + SHIFT + ^ Applies the Scientific number format with two decimal places.CTRL + SHIFT + # Applies to Date format with the day, month and year.CTRL + SHIFT + @ Applies to Time format with the hour and minute, and AM or PM.CTRL + SHIFT +! Design chapter to two decimal places, thousands separator, and minus sign (-) negative value.CTRL + SHIFT + *
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
PivotTable, it selects the entire PivotTable.CTRL + SHIFT +: Enters the current time.CTRL + SHIFT + "Copies the value in the cell above the active cell into the cell or the Formula Bar.CTRL + SHIFT + Plus (+) to open the Add dialog box, empty cells.CTRL + Minus (-) Displays the Delete dialog box to delete the selected cells.CTRL +; Add the current date.CTRL + `Substitute between displaying cell values and formulas.CTRL + 'Copies a formula from the cell above the active cell into the cell or the Formula Bar.CTRL +1 Displays the Format Cells dialog box.CTRL +2 Apply or remove bold formatting.CTRL +3 Apply or remove italic formatting.CTRL +4 Applies or remove the underline.CTRL +5 Applies or remove strikethrough.6 Change the CTRL hidden objects and displays.CTRL +8 Displays or hide the outline symbols.CTRL +9 Hides the selected rows.CTRL +0 Hides the selected columns.CTRL +
Select the entire worksheet.
If the worksheet contains data, CTRL + A selects the current region. Pressing CTRL + A a second time selects the entire worksheet.
When the cursor is on the right side of the function name in a formula, it seems Function Arguments dialog box appears.
CTRL + SHIFT + inserts the argument names and parentheses when the insertion point is at the right side of the name of the function in the formula.CTRL + B Apply or remove bold formatting.CTRL + C to copy the selected cells.Using CTRL + D Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.CTRL + F
Display the Find and Replace dialog box, with the Find tab selected.
SHIFT + F5 also displays this tab, while SHIFT + F4 to repeat the last Find action.
CTRL + SHIFT + F opens the Format Cells dialog box with the Font tab selected.CTRL + G
Displays the Go To dialog box.
F5 also displays this dialog box.CTRL + H Displays the Find and Replace dialog box, with the Replace tab selected.CTRL + I Apply or remove italic formatting.CTRL + K to open the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box, existing hyperlinks.CTRL + L Displays the Create Table dialog box appears.CTRL + N to create a new, blank workbook.CTRL + O
Displays the Open dialog box to open or find a file.
CTRL + SHIFT + O selects all cells that contain comments.CTRL + P
Display the Print tab in the Microsoft Office Backstage view.
CTRL + SHIFT + P opens the Format Cells dialog box with the Font tab selected.Using CTRL + R Fill Right command to copy the contents and format of the leftmost cell of a selected range into the appropriate cells.CTRL + S Saves the active file with the file name, location, and file format.CTRL + T Displays the Create Table dialog box appears.CTRL + U
Apply or remove the underline.
CTRL + SHIFT + U to turn expanding and collapsing of the formula bar.CTRL + V
Insert the clipboard contents into and replaces the selection. Available only after you have cut or copied an object, text, or cell contents.
CTRL + ALT + V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.CTRL + W Closes the selected workbook window.CTRL + X Cut the selected cells.CTRL + Y Repeats the last command or action, if possible.CTRL + Z Uses the Undo command to reverse the last command or to delete the last entry you typed.
Tip cominbations CTRL CTRL + E, CTRL + J, CTRL + M, CTRL + Q shortcut currently undefined.
Displays the Excel Help task pane.
CTRL + F1 displays or hides the ribbon.
ALT + F1 to make a graph of the data embedded in the selected area.
ALT + SHIFT + F1 inserts a new worksheet.F2
Edit the cell and position the cursor at the end of the active cell contents. It also moves the cursor into the Formula Bar when editing in a cell is turned off.
SHIFT + F2 to add or edit a cell comment.
Ctrl + F2 displays a preview of the Print tab in Backstage view.F3
Displays the Paste Name dialog box. Available only if there is a name in the workbook.
SHIFT + F3 displays the Insert Function dialog box.F4
Repeat the last command or action, if possible.
When a cell reference or range is selected in the formula, F4 through all the different combinations of absolute and relative references.
CTRL + F4 closes the selected workbook window.
ALT + F4 to close Excel.F5
Displays the Go To dialog box.
CTRL + F5 returns the window size of the selected workbook window.F6
Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a shared spreadsheet (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split pane when switching between panes and the Ribbon area.
Shift + F6 switches between the worksheet, Zoom controls, task pane, and ribbon.
CTRL + F6 switches to the next workbook window is more than one workbook window is open.F7
Displays the Spelling dialog box to check the spelling of the active worksheet or selected range.
CTRL + F7 perform the Move command if the workbook window is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.F8
Round to expand or off. In extend mode, Extended Selection appears in the status bar, and the arrow keys extend the selection.
SHIFT + F8 to add a nonadjacent cell or range of cells by using the arrow keys to dial.
CTRL + F8 perform the Size command (on the Control menu in the workbook window) when a workbook is not maximized.
ALT + F8 to display the Macro dialog box to create, run, edit, or delete a macro.F9
Calculates all worksheets in all open workbooks.
SHIFT + F9 calculates the active worksheet.
CTRL + ALT + F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL + ALT + SHIFT + F9 recheck the formula depends, and calculates all cells in all open workbooks, including cells not marked as required to be calculated.
CTRL + F9 minimizes a workbook window to an icon.F10
Have the key tips on or off. (Press ALT + does the same thing.)
SHIFT + F10 to display the shortcut menu for the selected item.
ALT + SHIFT + F10 Display the menu or message for the Error Checking button.
CTRL + F10 maximizes or restores the selected workbook window.F11
Create a diagram of the current range of data in a separate chart sheet.
SHIFT + F11 inserts a new worksheet.
ALT + F11 to open the Microsoft Visual Basic for Applications editor where you can create a macro in Visual Basic for Applications (VBA).F12 Displays the Save As dialog box appears.
Other useful shortcut keys
Shows the Key Tips (new shortcut) is recorded.
ALT, W, P switch between worksheets display Page Layout.
ALT, W, L switch normal view worksheet.
ALT, W, I change the worksheet Page Break Preview view.Arrow keys
Move one cell up, down, left, or right in the spreadsheet.
CTRL + Arrow moves to the edge of the area of the current data worksheet.
Shift + Arrow keys extend the selection of cells from a single cell.
CTRL + SHIFT + ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is empty, expand the selection to the next nonblank cell.
LEFT ARROW or RIGHT ARROW select the tab to the left or to the right, when the selected recording. When a submenu is open or selected, these arrow keys to move to the main menu and the submenu. When a ribbon tab is selected, this button navigation button tab.
DOWN ARROW or ARROW select the next or previous command when a menu or submenu is open. When a ribbon tab is selected, the navigation buttons above or below the group tab.
In the dialog box, use the arrow keys to move the option to open a drop-down list, or between options in the options.
ARROW or ALT + DOWN ARROW Open the drop-down list is selected.BACK SPACE
Delete one character to the left of the Formula Bar.
Delete the contents of the active cell.
Cell edit mode, delete the character to the left position.REMOVE
Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.
Cell edit mode, delete the character to the right place.END
END End lit. In End mode, you can press the arrow keys to move to the next nonblank cell in the same column or row as the active cell. If the cell is blank, then press the END key to move to the last cell in the row or column.
END select the last command on the menu when a menu or submenu is visible.
CTRL + END to move to the last cell on the worksheet to use the lowest row of the rightmost used column. If the cursor is in the formula bar, CTRL + END moves the cursor to the end of the text.
CTRL + SHIFT + END to extend the selection of cells to the last used cell (bottom right corner). If the cursor is in the formula bar, CTRL + SHIFT + END to select all the text in the formula bar from the cursor position to the end, this does not affect the height of the formula bar.ENTER
Ending a cell entry from the cell or the Formula Bar, and selects the cell below (by default).
In a data form, it moves to the first field in the next record.
Open the selected menu (press F10 to activate the menu bar) or perform the selected action commands.
In the dialog box, it performs the default action command button in the dialog box (the bold line, often the OK button).
ALT + ENTER start a new line in the same cell.
CTRL + ENTER fills the selected cell range with the current entry.
SHIFT + ENTER to complete a cell entry and selects the cell above.ESC
Cancel entry into the cell or the Formula Bar.
Closes an open menu or submenu, dialog box, or message window.
It also closes full screen mode when this mode is enabled, and return to the normal display mode shows the ribbon and status bar again.HOUSE
Move to the start line in the spreadsheet.
Move to the cell in the top left of the window when Scroll Lock is on.
Choose the first command on the menu when a menu or submenu is visible.
CTRL + HOME moves to the top of the spreadsheet.
CTRL + SHIFT + HOME to extend the selection to the cell in the worksheet.PAGE DOWN
Moves one screen down in a spreadsheet.
ALT + PAGE DOWN moves one screen to the right in the spreadsheet.
CTRL + PAGE DOWN moves to the next sheet in the workbook.
CTRL + SHIFT + PAGE DOWN selecting the current and next sheet in the workbook.PAGE UP
Move one screen in a spreadsheet.
ALT + PAGE UP moves one screen to the left of the worksheet.
CTRL + PAGE UP moves to the previous sheet in the workbook.
CTRL + SHIFT + PAGE UP selecting the current and previous sheet in the workbook.Space
In the dialog box, perform actions on the selected button, or selecting or clearing the check box.
CTRL + SPACEBAR selects all the columns in the table.
SHIFT + SPACEBAR selects the entire row of the table.
CTRL + SHIFT + SPACEBAR selects the entire worksheet.
If the worksheet contains data, CTRL + SHIFT + SPACEBAR selects the current region. When you press CTRL + SHIFT + SPACEBAR a second time selects the current region and its summary rows. When you press CTRL + SHIFT + SPACEBAR a third time selects the entire worksheet.
When an object is selected, CTRL + SHIFT + SPACEBAR selects all objects on a worksheet.
+ SPACEBAR displays the Control menu of the Excel window.TAB
Move one cell to the right in the spreadsheet.
Move to open up the cells on the worksheet is protected.
Move to the next option or option group dialog box.
SHIFT + TAB Move to the previous cell in a worksheet or the previous option in a dialog box.
CTRL + TAB to move to the next tab in a dialog box.
CTRL + SHIFT + TAB to move to the previous tab in a dialog box.
If you want to download Keyboard Shortcuts in Microsoft Excel 2010 you can download here