First click on cell E-3, then choose "freeze pane".
Please advise if this works for you.


Katy1986 wrote:
i have an excel file that is approx 45 columns by 250 rows. I would like to
be able to keep my first 4 columns and first 2 rows constantly visible whilst
scrolling through other data. I cannot seem to be able freeze both (i can
only freeze columns or rows - not both) but have seen it done. Can anybody
help?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1