Freezing panes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
news:[email protected]...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hiding freeze pane reference lines 3
Freeze panes 4
Freeze Panes loss 3
How to freeze one column vertically, one horizontal in same sprdsh 4
Why is there no Freeze Panes option in the Windows drop-down box? 2
ExcelFreezePanes shoud work horizontially and vertically together 2
How do I lock a section of cells in place 1
PowerPoint Freeze animation 1

Back
Top