Excel keyboard shortcuts and function keys for Windows. This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Excel 2. This includes the access keys that you can use for ribbon commands. For Excel Online, see Keyboard shortcuts in Excel Online. Wii Chip Firmware. RzLFR.jpg' alt='Ms Excel Cell Color Function' title='Ms Excel Cell Color Function' />MS Excel Tutorials Technical and managerial tutorials shared by internet community. You can submit your tutorial to promote it. Tips To keep this reference available when you work, you may want to print this topic. To print this topic, press CTRLP. To see an online workbook with this information, check out our workbook on Docs. This workbook lets you scroll, sort, and filter for any key combination. And, you can also download it. Get these keyboard shortcuts in a Word document at this link Excel 2. Windows keyboard shortcuts. GLx_4YzE/maxresdefault.jpg' alt='Ms Excel Cell Color Function' title='Ms Excel Cell Color Function' />This Excel tutorial explains how to use the Excel CELL function with syntax and examples. The Microsoft Excel CELL function can be used to retrieve information about. Frequently used shortcuts. If youre new to the Ribbon, the information in this section can help you understand the Ribbons keyboard shortcut model. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. The Ribbon groups related commands on tabs. For example, on the Home tab, the Number group includes the Number Format command. This table lists the most frequently used shortcuts in Excel 2. Uj8VaKw3Y/T7DjkyACfyI/AAAAAAAAAJ8/BNTFtoAymHQ/s1600/sumbycolor.jpg' alt='Ms Excel Cell Color Function' title='Ms Excel Cell Color Function' />To do this. Press. Close a workbook. CtrlWOpen a workbook. CtrlOGo to the Home tab. AltHSave a workbook. CtrlSCopy. CtrlCPaste. CtrlVUndo. CtrlZRemove cell contents. Delete key. Choose a fill color. AltH, HCut. CtrlXGo to Insert tab. AltNBold. CtrlBCenter align cell contents. AltH, A, then CGo to Page Layout tab. AltPGo to Data tab. AltAGo to View tab. AltWOpen context menu. ShiftF1. 0, or. Context key. Add borders. AltH, BDelete column. AltH,D, then CGo to Formula tab. AltMHide the selected rows. Ctrl9. Hide the selected columns. Ctrl0. Top of Page. Ribbon keyboard shortcuts. If youre new to the ribbon, the information in this section can help you understand the ribbons keyboard shortcut model. When you press the Alt key, letters appear in small images, called Key. Tips, next to tabs and commands on the ribbon, as shown in the following image. You can combine these letters with Alt to make shortcuts called Access Keys for ribbon commands. For example, AltH opens the Home tab, and AltQ goes to the Tell me box. Press Alt again to see Key. Tips for the commands on any tab. Access keys for ribbon tabs. To go directly to a tab on the ribbon, press one of the following access keys To do this. Press. Open the Tell me box on the Ribbon and type a search term for assistance or Help content. AltQ, and then enter the search term. Open the File page and use Backstage view. AltFOpen the Home tab and format text and numbers and use the Find tool. AltHOpen the Insert tab and insert Pivot. Tables, charts, add ins, Sparklines, pictures, shapes, headers, or text boxes. AltNOpen the Page Layout tab and work with themes, page setup, scale, and alignment. AltPOpen the Formulas tab and insert, trace, and customize functions and calculations. AltMOpen the Data tab and connect to, sort, filter, analyze, and work with data. AltAOpen the Review tab and check spelling, add comments, and protect sheets and workbooks. AltROpen the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros. Delbert Mcclinton- Midi Files'>Delbert Mcclinton- Midi Files. AltWTop of Page. Work in the ribbon with the keyboard. To do this. Press. Select the active tab of the ribbon, and activate the access keys. Alt or F1. 0. To move to a different tab, use access keys or the arrow keys. Move the focus to commands on the ribbon. Tab or ShiftTab. Move down, up, left, or right, respectively, among the items on the Ribbon. The Down Arrow, Up Arrow, Left Arrow, or Right Arrow key. Activate a selected button. Spacebar or Enter. Open the list for a selected command. The Down Arrow key. Open the menu for a selected button. AltDown Arrow. When a menu or submenu is open, move to the next command. Down Arrow key. Expand or collapse the ribbon. CtrlF1. Open a context menu. ShiftF1. 0Or, on a Windows keyboard. Context key between the right Alt and right Ctrl keysMove to the submenu when a main menu is open or selected. Left Arrow key. Top of Page. 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. ShiftTab. Move one cell up in a worksheet. Up Arrow key. Move one cell down in a worksheet. Down Arrow key. Move one cell left in a worksheet. Left Arrow key. Move one cell right in a worksheet. Right Arrow key. Move to the edge of the current data region in a worksheet. Ctrlarrow key. Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column. End, arrow key. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. CtrlEnd. Extend the selection of cells to the last used cell on the worksheet lower right corner. CtrlShiftEnd. Move to the cell in the upper left corner of the window when Scroll Lock is turned on. HomeScroll Lock. Move to the beginning of a worksheet. CtrlHome. Move one screen down in a worksheet. Page Down. Move to the next sheet in a workbook. CtrlPage Down. Move one screen to the right in a worksheet. AltPage Down. Move one screen up in a worksheet. Page Up. Move one screen to the left in a worksheet. AltPage Up. Move to the previous sheet in a workbook. CtrlPage Up. Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. Tab. Cycle through floating shapes, such as text boxes or images. CtrlAlt5, and then the Tab key repeatedly. Exit the floating shape navigation and return to the normal navigation. Esc. Top of Page. Keyboard shortcuts for formatting cells. To do this. Press. Open the Format Cells dialog box. Ctrl1. Format fonts in the Format Cells dialog box. CtrlShiftF or CtrlShiftPEdit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. F2. Add or edit a cell comment. ShiftF2. Open the Insert dialog to insert blank cells. CtrlShiftPlus Open the Delete dialog box to delete selected cells. CtrlMinus Enter the current time. CtrlShiftcolon Enter the current date. Ctrlsemi colon Switch between displaying cell values or formulas in the worksheet. Ctrlgrave accent Copy a formula from the cell above the active cell into the cell or the Formula Bar. Ctrlapostrophe Move the selected cells. CtrlXCopy the selected cells. CtrlCPaste content at the insertion point, replacing any selection. CtrlVOpen the Paste Special dialog box. CtrlAltVItalicize text or remove italic formatting. CtrlI or Ctrl3. Bold text or remove bold formatting. CtrlB or Ctrl2. Underline text or remove underline. CtrlU or Ctrl4. Apply or remove strikethrough formatting. Ctrl5. Switch between hiding objects, displaying objects, and displaying placeholders for objects. Ctrl6. Apply an outline border to the selected cells. CtrlShiftampersand Remove the outline border from the selected cells. CtrlShiftunderline Display or hide the outline symbols. Ctrl8. Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. CtrlDApply the General number format.