Wednesday, December 1, 2010

Freezing panes in Excel 2008 for Mac

I recently ran into a weird problem in Excel 2008 on a Mac. I couldn't freeze rows.

To freeze rows in Excel 2008 on a Mac:
  1. Put your cursor where you want to freeze your rows or columns in Excel
  2. Go to View
  3. Change it to Normal
  4. Go to Windows and select Freeze Panes

4 comments:

UU said...

Thanks! Useful!

Anonymous said...

very useful! Thanks...

ashleydw89 said...

I have tried this numerous times but it keeps freezing to row 22 and I am selected on row 1 so I am not sure what is going on, any help?

Anonymous said...

Select row 2 to freeze row 1