Keyboard Shortcuts For Navigating In Microsoft Office Excel Cells
|
To do this |
Press |
|---|---|
|
Move one cell to the previous cell in a worksheet |
Shift+Tab |
|
Move one cell to the next cell in a worksheet. |
Tab key |
|
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. |
Ctrl+Arrow key |
|
Enter the 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. |
Ctrl+End |
|
Extend the selection of cells to the last used cell on the worksheet (lower-right corner). |
Ctrl+Shift+End |
|
Move to the cell in the upper-left corner of the window when Scroll lock is turned on. |
Home+Scroll lock |
|
Move to the beginning of a worksheet. |
Ctrl+Home |
|
Move one screen down in a worksheet. |
Page down |
|
Move to the next sheet in a workbook. |
Ctrl+Page down |
|
Move one screen to the right in a worksheet. |
Alt+Page down |
|
Move one screen up in a worksheet. |
Page up |
|
Move one screen to the left in a worksheet. |
Alt+Page up |
|
Move to the previous sheet in a workbook. |
Ctrl+Page up |
|
Open the list of validation choices on a cell that has data validation option applied to it. |
Alt+Down arrow key |
|
Move to the cell in the upper-left corner of the window when Scroll lock is turned on. | Home+Scroll lock |
|
Exit the floating shape navigation and return to the normal navigation. |
Esc |
|
Scroll horizontally. |
Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right |
| To return to where the cursor is, when Scroll lock is turned on. | Ctrl-Backspace |
|
Open the Go To dialog box. |
F5 |
Related Post
- Fungsi Menu Pada Microsoft Excel 1
- Microsoft Excel Terms 1
- Study About Microsoft Office 1
- Ribbon File Pada Microsoft Office Word
- Jenis Section Break Dalam Microsoft Word
- Microsoft Word Equations 1
- Microsoft Office Equation Field
- Microsoft Word Modern Equation Structures
- Find Microsoft Word AutoSave Recover Location
- Ribbon In Microsoft Word
- Fungsi Menu Pada Microsoft Word 1
- Some Of Microsoft Excel Function
- Ribbon Home Pada Microsoft PowerPoint
- Powerpoint Text Alignment
Tidak ada komentar:
Posting Komentar