To Press
Move one cell in a given direction Arrow key
Move to the edge of the current data region CTRL+ arrow key
Move between unlocked cells on a protected worksheet TAB
Move to the beginning of the row HOME
Move to the beginning of the worksheet CTRL+HOME
Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1 CTRL+END
Move down one screen PAGE DOWN
Move up one screen PAGE UP
Move one screen to the right ALT+PAGE DOWN
Move one screen to the left ALT+PAGE UP
Move to the next sheet in the workbook CTRL+PAGE DOWN
Move to the previous sheet in the workbook CTRL+PAGE UP
Move to the next workbook or window CTRL+F6 or CTRL+TAB
Move to the previous workbook or window CTRL+SHIFT+F6 or CTRL+SHIFT+TAB
Move to the next pane F6
Move to the previous pane SHIFT+F6
Scroll to display the active cell CTRL+BACKSPACE
In End mode, to Press
Turn End mode on or off END
Move by one block of data within a row or column END, arrow key
Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1 END, HOME
Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command) END, ENTER
With SCROLL LOCK turned on, to Press
Turn SCROLL LOCK on or off SCROLL LOCK
Move to the cell in the upper-left corner of the window HOME
Move to the cell in the lower-right corner of the window END
Scroll one row up or down UP ARROW or DOWN ARROW
Scroll one column left or right LEFT ARROW or RIGHT ARROW
Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.
13 Killer Excel 2007 Shortcuts
Apply the outline border to the selected cells. [ Ctrl-Shift-& ]
Apply the Date format with the day, month, and year.[ Ctrl-Shift-# ]
Apply the Time format with the hour and minute, and AM or PM. [ Ctrl-Shift-@ ]
Enter the current time. [ Ctrl-Shift-: ]
Enter the current date. [ Ctrl-; ]
Hide the selected rows. [ Ctrl-9 ]
Hide the selected columns. [ Ctrl-0 ]
Alternate between displaying cell values and displaying formulas in the worksheet. [ Ctrl-` ]
Display the Find and Replace dialog box, with the Replace tab selected. [ Ctrl-H ]
Display the Insert Hyperlink dialog box for new hyperlink. [ Ctrl-K ]
Display the Print Preview window. [ Ctrl-F2 ]
Switch to the next workbook window. [ Ctrl-F6 ]
Display the Macro dialog box to create, run, edit, or delete a macro. [ Alt-F8 ]
Move one cell in a given direction Arrow key
Move to the edge of the current data region CTRL+ arrow key
Move between unlocked cells on a protected worksheet TAB
Move to the beginning of the row HOME
Move to the beginning of the worksheet CTRL+HOME
Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1 CTRL+END
Move down one screen PAGE DOWN
Move up one screen PAGE UP
Move one screen to the right ALT+PAGE DOWN
Move one screen to the left ALT+PAGE UP
Move to the next sheet in the workbook CTRL+PAGE DOWN
Move to the previous sheet in the workbook CTRL+PAGE UP
Move to the next workbook or window CTRL+F6 or CTRL+TAB
Move to the previous workbook or window CTRL+SHIFT+F6 or CTRL+SHIFT+TAB
Move to the next pane F6
Move to the previous pane SHIFT+F6
Scroll to display the active cell CTRL+BACKSPACE
In End mode, to Press
Turn End mode on or off END
Move by one block of data within a row or column END, arrow key
Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1 END, HOME
Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command) END, ENTER
With SCROLL LOCK turned on, to Press
Turn SCROLL LOCK on or off SCROLL LOCK
Move to the cell in the upper-left corner of the window HOME
Move to the cell in the lower-right corner of the window END
Scroll one row up or down UP ARROW or DOWN ARROW
Scroll one column left or right LEFT ARROW or RIGHT ARROW
Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.
13 Killer Excel 2007 Shortcuts
Apply the outline border to the selected cells. [ Ctrl-Shift-& ]
Apply the Date format with the day, month, and year.[ Ctrl-Shift-# ]
Apply the Time format with the hour and minute, and AM or PM. [ Ctrl-Shift-@ ]
Enter the current time. [ Ctrl-Shift-: ]
Enter the current date. [ Ctrl-; ]
Hide the selected rows. [ Ctrl-9 ]
Hide the selected columns. [ Ctrl-0 ]
Alternate between displaying cell values and displaying formulas in the worksheet. [ Ctrl-` ]
Display the Find and Replace dialog box, with the Replace tab selected. [ Ctrl-H ]
Display the Insert Hyperlink dialog box for new hyperlink. [ Ctrl-K ]
Display the Print Preview window. [ Ctrl-F2 ]
Switch to the next workbook window. [ Ctrl-F6 ]
Display the Macro dialog box to create, run, edit, or delete a macro. [ Alt-F8 ]
No comments:
Post a Comment