Freezing panes
 

how do i freeze panes vertically in Microsoft Excel Or even freeze panes
horizontally and vertically ?

Select the cell that should be the top left of the scrollable
(non-frozen) area, and choose Freeze Panes from the Window menu.


"Excel User leka" <Excel User leka @discussions.microsoft.com
wrote in message
...
how do i freeze panes vertically in Microsoft Excel Or even
freeze panes
horizontally and vertically ?

Hi Leka,
Actually you want to go past what you want to freeze.
Chip stayed up too late last night.

to freeze column A, first select column B
to freeze Columns A & B, first select column C
to freeze row 1, first select row 2
to freeze Column A and Row 1, first select cell B2

then Window (menu), Freeze
to unfreeze use Window, unfreeze

More information
http://www.mvps.org/dmcritchie/excel/freeze.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chip Pearson" wrote in message ...
Select the cell that should be the top left of the scrollable
(non-frozen) area, and choose Freeze Panes from the Window menu.


"Excel User leka" <Excel User leka @discussions.microsoft.com
wrote in message
...
how do i freeze panes vertically in Microsoft Excel Or even
freeze panes
horizontally and vertically ?