Microsoft Office Tutorials and References
In Depth Information
Moving Around the Excel Screen
Active Worksheet
Another way to use the mouse within Excel is
to toggle between worksheets in your current
workbook. New workbooks contain three
worksheets, labeled Sheet1, Sheet2, and Sheet3.
Clicking any worksheet tab makes that sheet
appear on top of the other worksheets as the new
active worksheet. Chapter 6, “Managing Large
Amounts of Excel Data,” will describe how to use
multiple worksheets.
Finally, you can use the mouse to select the Name
box. If you know the cell address, you can type it
into the Name box, press Enter, and move the
worksheet directly to that cell.
Figure 1-9
Sheet3 is the active worksheet in this Excel workbook.
Scroll Bar Arrows
Tip
If the Ctrl+End keystroke takes you to a
blank cell, then Excel remembered
something you didn’t. This keystroke moves to
the intersection of the last row and column
that contains data, even if that cell is
blank.
Figure 1-10
The scroll bars allow you to move quickly
through an Excel sheet with the mouse.
Using a Mouse
Any cell that you click on becomes the new
active cell. You can use your mouse to select any
cell that you can see on the spreadsheet. Use the
scroll bars to make more of the worksheet visible.
Both the horizontal and vertical scroll bars have
arrows at each end (see Figure 1-10) to continue
scrolling the worksheet.
Tip
If you want to see the last cell in the
Excel worksheet, type the cell address
XFD1048576 into the Name box and
press Enter. Then, press Ctrl+Home to
return to the beginning of the worksheet.
 
Search JabSto ::




Custom Search