View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean[_8_] Dean[_8_] is offline
external usenet poster
 
Posts: 407
Default 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