#1
|
|||
|
|||
Possible to freeze both a column and a row?
I would like to freeze both a column (A) and a row (5) so when I scroll to the right column A stays froze, or when I scroll down row 5 also stays frozen. I can get one or the other, but not both together.
Is this possible? Thanks! Bryan |
#2
|
||||
|
||||
Hi Bryan,
Yes this is possible. Select the cell B6 and then go to View > Freeze Panes > Freeze Panes. Column A and Rows 1:5 will then be frozen. |
#3
|
|||
|
|||
Perfect. Thanks again, Colin!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
How can I freeze a section (i.e. the side bar of a letterhead template) | emathews | Word | 1 | 06-06-2011 02:47 PM |
Need to search a column for a macth and return a result from a third column | pdfaust | Excel | 2 | 02-03-2011 03:02 PM |
Movies Freeze | mam142 | PowerPoint | 0 | 09-23-2010 09:19 AM |
outlook causes computer to freeze | broglet | Outlook | 0 | 03-16-2010 11:39 PM |