![excel keyboard shortcut to move down sort menu excel keyboard shortcut to move down sort menu](https://1734811051.rsc.cdn77.org/data/images/full/381355/microsoft-excel-new-updates-unlock-default-full-list-keyboard-shortcuts.jpg)
If a row or column field is selected, press DOWN ARROW to move to the first item of data in the field, and then press an arrow key to move to the next or previous item or back to the field. CTRL+TAB Select the detail cells for the next item in the column area CTRL+ENTER Select the detail cells for the next item in the row area SHIFT+CTRL+TAB Select the detail cells for the previous item in the column area SHIFT+CTRL+ENTER Select the detail cells for the previous item in the row area Arrow keys Move the selection in the direction of the arrow key. If the current cell is the topmost cell, SHIFT+ENTER selects the last cell in the previous column. SHIFT+ENTER Select the cell above the current cell. If the current cell is the leftmost cell, SHIFT+TAB selects the last cell in the previous row. Good luck.The TAB key Move the selection from left to right, and then down ENTER Move the selection from top to bottom, and then to the right SHIFT+TAB Select the cell to the left.
![excel keyboard shortcut to move down sort menu excel keyboard shortcut to move down sort menu](https://fasteratexcel.com/wp-content/uploads/2015/12/excel-sort-shortcuts.gif)
If you reached for the rodent, review the two tablesĪbove, go back to step 1 and try again. Move back into cell D4 and Copy your nameĮach of the steps in the list above should have been accomplished Insert a new worksheet into the workbookĥ. Open Microsoft Excel,įrom this point forward, do not use your mouseĢ. Keyboard combinations check the Excel help index. To the beginning of a document or to the left edge of To the end of a document or to the right edge of the
![excel keyboard shortcut to move down sort menu excel keyboard shortcut to move down sort menu](https://images.idgesg.net/images/article/2017/08/05a-navigation-keys-plus-shortcuts-to-access-menus-commands-100734056-large.jpg)
One character to the left in the formula bar or one One character to the right in the formula bar or one Non blank cell to the left or below a selected cell In the formula bar, or one cell to the left in the worksheetĮxtend selection one character to the right in the formulaīar, or one cell to the right in the worksheet Text is already selected and you want to extend the selection areaĮxtend selection one character to the left Select the current region around the active cellĭisplays all formulas in a worksheet, repeat to hide In a cell with a hyperlink, this activates the hyperlink Prints the active file, also gives the opportunity to change print optionsĬreate a chart that uses the current range Move between unlocked cells on a protected worksheet In print preview, move to the last page when zoomed outĬomplete a cell entry and move up in the selection In print preview, move to the first page when zoomed out Select the previous sheet in the workbookĬomplete a cell entry and move to the right in the selectionĬomplete a cell entry and move to the left in the selectionĬomplete a cell entry and move down in the selection Release the held keys when the action is completed Hold down the first key(s) and tap the last key one time.
![excel keyboard shortcut to move down sort menu excel keyboard shortcut to move down sort menu](https://s3.studylib.net/store/data/007687242_2-3108058570beed23af050dc14a2b988b-768x994.png)
Underline - Formats selected text make text underlined or remove Redo - After an action has been undone, it can be reinstated Italic - Formats selected text make text italic or remove italic Prints the active file, also gives the opportunity toįind - Searches for specified text in the active documentīold - Formats selected text make text bold, or remove bold formatting Saves the active document with its current file Paste - Inserts the contents of the clipboard at the insertion point The Ctrl or Alt key down and strike the letter keyĬut- Removes the selection from the active document and places itĬloses the active window, but does not Exit Excel. In each pull down menu you will see keyboard commands given in If you forget one of these, use the mouse and go to You can avoid reaching for the mouse if you are familiar