Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
Using freezed panes in excel, how do I save the page as HTML? | Excel Discussion (Misc queries) | |||
Saving as web page for workbook with frozen panes | Excel Discussion (Misc queries) | |||
Freezing? Rows | Excel Discussion (Misc queries) | |||
Excel should allow independent zoom adjustment of split panes | Excel Discussion (Misc queries) |