Can I freeze BOTH a column and a row in the same spreadsheet?

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I wondered if there was a way to freeze a row and a column in the same
spreadsheet. I have frozen horizontally, but now I want to freeze
vertically. When I try to do this I am only given the option to "unfreeze
pane". Thanks for your help!! Todd
 
Select the top left cell of the region you want to scroll and freeze the
panes. For example, to freeze rows 1 and 2 and columns A and B, select C3
and freeze panes.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

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

Unable to freeze panes 16
Freeze multiple rows/columns in Excel 2007 11
freeze row AND column simultaneously 3
freeze and split at the same time? 1
How do I freeze/ unfreeze a window pane in Excel 2007? 2
Excel 2007 - freeze multiple panes? 2
How do I freeze 2 top rows in Excel 2007 3
Freeze Panes? 1

Back
Top