Microsoft Office Tutorials and References
In Depth Information
Using the Current Range to Navigate
Figure 7.3.
Figure 7.3. End+arrow key causes Excel to jump over a range of blank cells
End+arrow key causes Excel to jump over a range of blank cells
or a contiguous range of cells.
or a contiguous range of cells.
If you press the End key to move right or down from the last cell that con-
tains data, the cell pointer jumps to the last row or column in the spread-
sheet. In a blank worksheet, you can press End+down arrow and End+right ar-
row to move to XFD1048576.
Using the Current Range to Navigate
Using the Current Range to Navigate
If your data has many blank cells, using Ctrl+arrow keys or Ctrl+End key
will lead to frustration.
You can press Ctrl+* to select the current region. A current region starts
from the current nonblank cell and extends out in all directions until Excel
encounters a completely blank row, a completely blank column, or the edge
of the spreadsheet.
Then you can press Ctrl+. (that is, Ctrl plus the period key) to move the act-
ive cell to each corner of the selection. From the top-left cell of a region,
you can press Ctrl+* and then press Ctrl+. twice to go to the last used cell
in the current region.
Search JabSto ::




Custom Search