Goodwill Community Foundation creating
opportunities for a better life Excel
worksheets can have a lot of cells and
sometimes you may find that you want to
view two different parts of the
spreadsheet at the same time for example
in this spreadsheet I have a list of
salespeople in the first column but when
I scroll to the right those names
disappear which makes it really hard to
see who the sales data belongs to we can
fix this by freezing the first column so
we'll always say visible first go to the
View tab and click freeze panes and you
have a few different options but we just
want to freeze the first column
now when we scroll we can easily see the
names of each salesperson no matter
where we are in the spreadsheet
this one she also has dates in the
second row and I'd like to freeze them
so they'll stay visible when I scroll
down but in this example it's going to
work a bit differently and that's
because it's Row two and you can see why
if I go to the freeze panes command
there's an option to freeze the top row
but there isn't an option to freeze just
the second row by itself instead we'll
need to freeze the top two rows since
we've already frozen the first column
will first need to reset the spreadsheet
by selecting unfreeze panes and now you
have two options you can either select
the row below the rows that you want to
freeze as we're three in this case or
you can select a single cell such as b3
if you select only one cell it will
freeze the rows above it and also any
columns to the left and that's exactly
what we want here next go to the freeze
panes command and select freeze panes
and now you can see a thin line in
between rows 2 & 3 and also a line
between columns a and B when I scroll I
can see all of my header rows and
columns no matter where I am in the
spreadsheet sometimes you may need to
work with different parts of the
spreadsheet at the same time there are a
couple of ways to do this one is to
click the new window command on the View
tab this will give you two separate
windows and you may need to rearrange
them so that you can view both at the
same time both of these windows are
showing the same file and we can use it
to view two different parts of the
worksheet or if the workbook has
multiple sheets you can view two of them
side by side so I could view the 2013
sales in one window and the 2014 sales
another which makes it very easy to
compare the two years if you want to go
back to just one window you can close
either one by clicking the close button
in the upper right corner you can then
resize the window as needed or just
click the maximize button another way to
view two different parts of a worksheet
is to use the split feature this is a
little bit like freezing panes except
instead of freezing them you can
actually scroll each section
independently first if you have any
frozen panes you'll need to go back to
the freeze panes command then choose
unfreeze panes then select the cell
where you want the split to appear
usually somewhere near the middle of
your spreadsheet and then click the
split command and now you can see that
there are vertical and horizontal
dividers there are also four scroll bars
which we can use to scroll the different
sections now if you find that this view
is a little bit too cluttered you can
make it simpler by removing one of the
dividers if you drag the vertical
divider all the way to the left it will
disappear and you just have a horizontal
divider now by scrolling the top and
bottom sections we can compare the data
for any two salespeople really easily
for example how about David Carlson and
Moe as a post
depending on your spreadsheet some of
these view options may be better than
others in this example the header rows
and columns are really important so the
freeze panes feature is probably our
best choice you'll want to try all the
view options and see which one works
best for your spreadsheet