If a range is selected, copies the uppermost cell into the lower cells. Select to beginning of line of text (or cell A1)įind - (Hint: Use for searching web pages such as this one)Įdit active cell, (In Windows Explorer, rename selected file)Įnter current date (Ctrl+Shift+: enter the current time)Īlso, move to next and previous tabs (such as in multi-tab dialog boxes)įill (Copy) Down - If a single cell is selected, copies the cell immediately above it. Move to beginning of line of text (or last nonblank row/column) Select to end of line of text (or data region) Move to end of line of text (or data region)

Įxtend selection by one word, to next change in empty vs. = Shortcuts commonly used in other software for the same purpose.Ĭancel - Used in many situations where you'd expect 'cancel' to be appropriate, including closing menus, dialog boxes, and message windows.Īccept/Done/Submit - Can usually be used in place of clicking on 'Accept', 'OK', 'Search', 'Submit', etc.Įxtend selection by one character, cell, row, column. Everyone's work is different, but if you do a lot of text editing, using the keyboard to navigate and select text can save a lot of time.

#1 Recommendation: Learn to use the combination of Ctrl, Alt, and Shift along with the Arrow Keys to navigate and select text. These are some of the most-used shortcuts, so they are the ones to start with first.ĭownload the Excel Keyboard Shortcut 1-Pager (.pdf)

The PDF doesn't include all possible shortcuts, but that's the point. Print a page of shortcuts to keep next to your computer. View Larger Image Excel Keyboard Shorcuts

Excel shortcut keys for get to a1