how can i freeze first coloumn & first row of exel sheet

  • Thread starter Thread starter sthakur
  • Start date Start date
the only way i see in office 07 is to select view on the top ribbon and then
selct the freeze pane icon- this give you only 3 options- the top row, the
top column or unfreeze. thus, i can not select both- only one. How do i get
both the top column and far right row BOTH to freeze in 07?
 
It shows UNfreeze because you have already frozen panes. So click
UNfreeze, then select B2 and then Freeze Panes.
 
To OP, not Bob

What is the "far right row" and "top column"?

Are you confused with rows and columns?

Rows above and columns left of selected cell will remain frozen.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

highlight row and coloumn of selected cell 6
Applying settings across Worksheets 2
sorting coloumns 0
Hide Rows or Coloumns using formulas 5
How to apply Macro on a same type of format but in excess content? 1
Hidding rows when sorting 1
advance lookup and paste 1
Text Functions 2

Back
Top