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

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
 
C

Chip Pearson

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

Top