Ctrl+ Shift+ : colon Insert current time. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. Up arrow key Move one cell down in a worksheet. Ctrl+ F Display the Find and Replace dialog box with Find selected. Tip: The Ctrl combinations Ctrl+J and Ctrl+M are currently unassigned shortcuts.
Closes an open menu or submenu, dialog box, or message window. Open the Insert hyperlink dialog. In a worksheet that has been split View menu, Manage This Window, Freeze Panes, Split Window command , F6 includes the split panes when switching between panes and the Ribbon area. Closes an open menu or submenu, dialog box, or message window. You get to use your creativity and work with a variety of different media formats. Ctrl+Q Displays the Quick Analysis options for your data when you have cells that contain that data selected. Also clears the content of the active cell.
Ctrl+ u or ctrl+ 4 Apply or remove an underline. Then, press the key for the button you want. F1 Get help on the selected command or control in the Ribbon. Ctrl+2 Applies or removes bold formatting. For example, on the Home tab, the Number group includes the Number Format command. F12 Displays the Save As dialog box. Alt+Down arrow key When a menu or submenu is open, move to the next command.
Ctrl+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. F7 Display the Spelling dialog box. Ctrl+8 Toggles the outline symbols. Left arrow key Excel keyboard shortcut reference Keyboard shortcuts for navigating in cells To do this Press Move to the previous cell in a worksheet or the previous option in a dialog box. Alt+ Arrow Down Display the AutoComplete list e. Ctrl+0 zero Hide the selected columns. This makes all the Key Tip badges for that tab's buttons appear, as shown in the following image.
Ctrl+I Applies or removes italic formatting. Ctrl+Shift+A Inserts argument names into a formula. To do this Press Close a workbook Ctrl+W Open a workbook Ctrl+O Go to the Home tab Alt+H Save a workbook Ctrl+S Copy Ctrl+C Paste Ctrl+V Undo Ctrl+Z Remove cell contents Delete key Choose a fill color Alt+H, H Cut Ctrl+X Go to Insert tab Alt+N Bold Ctrl+B Center align cell contents Alt+H, A, C Go to Page Layout tab Alt+P Go to Data tab Alt+A Go to View tab Alt+W Open context menu Shift+F10, or Context key Add borders Alt+H, B Delete column Alt+H, D, C Go to Formula tab Alt+M Hide the selected rows Ctrl+9 Hide the selected columns Ctrl+0 Ribbon keyboard shortcuts If you're new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model. Using the Shortcut Keys Excel 2010 automatically recognizes all the Ctrl shortcut keys that were used in legacy versions of Excel. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. From here use arrow keys to move by blocks of data, home to move to last cell, or enter to move to the last cell to the right.
Alt+ Arrow Down Open the selected drop-down list box. Ctrl+ Home Move to the beginning of a worksheet. Work with Clipboard Ctrl+ C Copy contents of selected cells. Ctrl+Enter fills the selected cell range with the current entry. F12 Displays the Save As dialog box. F5 also displays this dialog box. Ctrl+Shift+Spacebar Selects the entire worksheet.
Alt+U Apply or remove the upward diagonal border. F10 Turns key tips on or off. Ctrl+Tab Move between Two or more open Excel files. F4 Repeats the last command or action, if possible. Ctrl+F3 Open Excel Name Manager. Ctrl+W or Ctrl+F4 Close workbook.
Home+Scroll Lock Move to the beginning of a worksheet. Ctrl+ 6 Alternate between hiding objects, displaying objects, and displaying placeholders for objects. The Ribbon groups related commands on tabs. Available only if names have been defined in the workbook. Ctrl+Shift+F Opens the drop-down menu for fonts. Also selects the last command on the menu when a menu or submenu is visible.
This article itemizes the keyboard shortcuts for Excel for Windows. Alt, W, I switches the worksheet to Page Break Preview view. In a PivotTable, it selects the entire PivotTable report. Alt+W Work in the ribbon with the keyboard To do this Press Select the active tab of the ribbon, and activate the access keys. F1 Display the Excel Help task pane. When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. Ctrl+Enter Fill the selected cell range with the current entry.