Freeze and Split
 

Perhaps I am confusing printing (where you can set up rows or columns that
repeat on every page) with viewing (which is what I want to do now), but I
thought there was a way to use freeze (panes) and split (screen) so as to be
able to always see, say, the top 3 rows, AND the two leftmost columns, i.e.,
as you scroll around the page, both remain in view. It seems like when I
set one of them up and try to do the other, it removes the first one. Can
someone tell me how to do both together, or some other way to accomplish
what I'm asking for?

Thank you very much!
Dean

Freeze and Split
 

Dean,

Select cell C4 and Freeze Panes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Dean" wrote in message
...
Perhaps I am confusing printing (where you can set up rows or
columns that repeat on every page) with viewing (which is what
I want to do now), but I thought there was a way to use freeze
(panes) and split (screen) so as to be able to always see, say,
the top 3 rows, AND the two leftmost columns, i.e., as you
scroll around the page, both remain in view. It seems like
when I set one of them up and try to do the other, it removes
the first one. Can someone tell me how to do both together, or
some other way to accomplish what I'm asking for?

Thank you very much!
Dean

Freeze and Split
 

That was too easy - obviously I never understood the two dimensional nature
of "freeze"!

Thanks!
D

"Chip Pearson" wrote in message
...
Dean,

Select cell C4 and Freeze Panes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Dean" wrote in message
...
Perhaps I am confusing printing (where you can set up rows or columns
that repeat on every page) with viewing (which is what I want to do now),
but I thought there was a way to use freeze (panes) and split (screen) so
as to be able to always see, say, the top 3 rows, AND the two leftmost
columns, i.e., as you scroll around the page, both remain in view. It
seems like when I set one of them up and try to do the other, it removes
the first one. Can someone tell me how to do both together, or some
other way to accomplish what I'm asking for?

Thank you very much!
Dean