| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I freeze BOTH a column and a row in the same spreadsheet?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I freeze BOTH a column and a row in the same spreadsheet?
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) "Todd" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I freeze the top and side of a spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I freeze data in the spreadsheet so no one can change it? | Excel Discussion (Misc queries) | |||
| Freeze column AG | Excel Discussion (Misc queries) | |||
| Large Spreadsheet - Freeze On Recalculate | Excel Worksheet Functions | |||
| freeze row and column | Excel Discussion (Misc queries) | |||
Linear Mode
