Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Horizontal
Split Bar
Vertical Split
Bar
Tip
You can also split a worksheet using the
horizontal or vertical split bars. For
example, drag the horizontal split bar
from its place just below the Formula bar
down onto the worksheet, and drop it
where you want to split the screen
horizontally. To split the screen vertically,
drag the vertical split bar from its place
at the right end of the horizontal scroll
bar to the left and drop it where you
want to split a worksheet vertically. By
the way, no matter whether you drag
split bars onto a worksheet to split it or
use the Split button, you can still drag
the split bars once they are in place to
adjust the size of the panes.
Figure 6-32
Split the screen to create views of
non-contiguous areas of the worksheet.
To split a screen, click any cell and then click
the Split button on the View tab. The split bars
appear above and/or to the left of this cell. Click
within any pane and scroll to get the view you
want. In Figure 6-32, I split the screen into four
parts, scrolled down in the bottom left pane to
view one of the last employees—Shiree Wilson.
In the upper-right pane, I scrolled to the right
to view the paycheck breakdown for that same
employee. To remove the split bars, click the
Split button on the View tab again.
Hiding Rows and Columns
One way that you can easily simplify a large
worksheet and make it easier to work with is to
temporarily hide the rows or columns you aren’t
currently working on. Doing so instantly shrinks
a large worksheet and makes it workable. In
addition, hidden rows or columns are not included
when you print a worksheet, so hiding rows or
columns enables you to quickly print exactly
what you want (such as non-contiguous rows or
columns), while hiding data you don’t want to
share.
 
Search JabSto ::




Custom Search