Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Managing Large Amounts of Data
the bottom section and columns G through K on
the right. Choose View>Window>Freeze
Panes>Unfreeze Panes to remove the freeze from
row and column headings.
Splitting a window into multiple panes.
Drag the horizontal split bar up or down, or drag
the vertical split bar left or right to resize the
window sections, or double-click any part of the bars
that divide the panes to remove that particular split.
Freezing column titles.
Choose View>Window>Split again to remove the
Splitting the Excel Screen
Sometimes you need to see two or more different
sections of your worksheet at the same time, but
your worksheet is too large to view both sections.
Excel includes a feature which allows you to split a
window into two or four sections which you can
move independently of each other.
Hiding Rows and Columns
If you have rows or columns you don't really need
to see, or that you don't want to print, you can
hide them from view. Hiding them doesn't delete
them or make their data inaccessible; it only keeps
them out of view. When you hide rows or columns,
Excel is actually changing the row height or
column width to zero.
Click anywhere in a row and column where you
want to split your screen. This is usually
somewhere around the middle of the screen. Choose
View>Window>Split. Excel splits the window
horizontally into two or four panes, each separated
from other panes by bars. Each pane has its own
set of scroll bars (see Figure 11-19).
You can hide multiple columns at one
time or multiple rows at one time, but
you can’t hide both columns and rows in
a single step.