Microsoft Office Tutorials and References
In Depth Information
Tips for Navigating the Big Grid
However, for the most part, the new limits are incredible and allow much lar-
ger analyses to happen in Excel instead of elsewhere.
Tips for Navigating the Big Grid
The navigation tips described in the following sections are not new to Excel
2013. However, with 17 billion cells, there is a better chance that you don t
want to be scrolling around with the Page Up and Page Down keys.
Using Shortcut Keys to Move Around
Using Shortcut Keys to Move Around
A variety of shortcuts enable you to move quickly around a worksheet:
Using the End Key to Navigate
Using the End Key to Navigate
The End key is one of the six keys above the arrow keys on a standard U.S.
keyboard. When you press the End key, an indicator lights up in the status
bar of the Excel window. When Excel is in End mode, you can press an arrow
key or the Home key. Pressing an arrow key takes you to the edge of a contigu-
ous range of cells. Pressing Home while in End mode takes you to the last-
used cell in the worksheet.
In Figure 7.3 , pressing End and then the down arrow key causes the cell point-
er to jump from C34 to C36. When the cell pointer is on the edge of a range,
pressing End followed by the down arrow again causes Excel to jump over a
range of blank cells and land on the starting edge of the next range. For ex-
ample, pressing End+down arrow from C36 causes the cell pointer to jump to
C39. Press End and then right arrow from C39 to jump the gap and land in F39.
Search JabSto ::

Custom Search