You'll find keyboard shortcuts for other Office applications, too. Press Alt again to see KeyTips for the commands on any tab. We share our experience and knowledge through blog articles, demos, eBooks, videos and glossary terms for the benefit of webmasters and tech community. Ctrl+F1 Open a context menu. The selected text will immediately be strikethrough.
Ctrl + Home Move to the beginning of a worksheet A1 cell. To continue with shortcuts, use the new Key Options below. Moves between unlocked cells in a protected worksheet. Ctrl+; Enters the current date. Page Down Move to the next sheet in a workbook. Ctrl+ Down Ctrl+F Search current sheet. Right arrow key Move to the edge of the current data region in a worksheet.
Ctrl+F6 switches to the next workbook window when more than one workbook window is open. End mode turns off automatically after pressing the arrow key. Microsoft Excel Keyboard Shortcuts The keyboard shortcuts are tested and works in most versions of the Microsoft Excel in Windows based computers. Alt+F11 Opens the Visual Basic editor. The asterisk key is available on the numeric keyboard for independent selection. Note: If an action that you use often does not have a shortcut key, you can to create one. Ctrl+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
Web page: Shortcut count: 309 report this ad Similar programs. Shift+Down Arrow Extends the highlighted area down one cell. To jump to a certain slide while presenting, press a number and then Enter. Turns End mode on or off. Ctrl + ; Enter the current date. Ctrl+B Bold all cells in the highlighted section. Left arrow key Move one cell right in a worksheet.
Pressing Ctrl+Shift+Spacebar a second time selects the current region and its summary rows. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. Thanks for any help you might give — it adds time to manually do the strike-throughs as I edit long docs. F2 Edits the active cell and positions the insertion point at the end of the cell contents. Alt+M Open the Data tab and connect to, sort, filter, analyze, and work with data.
Shift+Tab moves to the previous cell in a worksheet or the previous option in a dialog box. F6 Switches between the worksheet, Ribbon, task pane, and Zoom controls. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again. Ctrl+Shift+F3 Creates names by using those of either row or column labels.
F8 Add a non-adjacent cell or range to a selection of cells by using the arrow keys. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color. Still, let me write them down again for beginners. Ctrl+Shift+Page Up Extend the selection of cells by one cell. Arrow keys Move one cell up, down, left, or right in a worksheet. When a ribbon tab is selected, these keys navigate the tab buttons. Alt, W, L switches the worksheet to Normal view.
Shortcut menu Shift + F1 Fn + Shift + F1. Ctrl+Arrow 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. Ctrl+Shift+F opens the Format Cells dialog box with the Font tab selected. If you want to become a master of Excel financial analysis and an expert on building financial models then you've come to the right place. This table lists the most frequently used shortcuts in Excel. Thank you for using TechWelkin! Down arrow key Move one cell left in a worksheet.