![]() |
#1
|
|||
|
|||
![]()
I use Excel 2007.
The ribbon options for freezing panes only include Top Row, and First Column. How can I freeze the top five rows, and first three columns? Thanks, Gary Last edited by Gary Drumm; 07-22-2013 at 10:40 AM. Reason: typo |
#2
|
|||
|
|||
![]()
As i know, there are 3 options: Top Row, First Column , but the first option in drop down list is : Freeze Panes , (based on current selection), which means that you have to select a cell first and this option will freeze all the rows above the selected cell and all the columns to the left of selected cell...
|
#3
|
|||
|
|||
![]()
Thanks Catalin.B.
Gary |
#4
|
|||
|
|||
![]()
I didn't see that option, because apparently I already had some panes frozen.
After I un-froze the sheet, I was then able to place my cursor as you suggested, and re-freeze, and then it worked great. Thanks again, Gary |
#5
|
||||
|
||||
![]()
With all that freezing, sometimes our brain functions get slower
![]()
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Slide Show freeze PPT 2010 | bangonay | PowerPoint | 0 | 05-15-2012 01:38 AM |
![]() |
bryanarn | Excel | 2 | 03-11-2012 09:54 AM |
![]() |
emathews | Word | 1 | 06-06-2011 02:47 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 |