Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2013, 10:39 AM
Gary Drumm Gary Drumm is offline Freeze more than just the top row, or first column Windows XP Freeze more than just the top row, or first column Office 2007
Advanced Beginner
Freeze more than just the top row, or first column
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default Freeze more than just the top row, or first column

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
Reply With Quote
  #2  
Old 07-22-2013, 09:42 PM
Catalin.B Catalin.B is offline Freeze more than just the top row, or first column Windows Vista Freeze more than just the top row, or first column Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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...
Reply With Quote
  #3  
Old 07-23-2013, 09:42 AM
Gary Drumm Gary Drumm is offline Freeze more than just the top row, or first column Windows XP Freeze more than just the top row, or first column Office 2007
Advanced Beginner
Freeze more than just the top row, or first column
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

Thanks Catalin.B.
Gary
Reply With Quote
  #4  
Old 07-23-2013, 10:02 AM
Gary Drumm Gary Drumm is offline Freeze more than just the top row, or first column Windows XP Freeze more than just the top row, or first column Office 2007
Advanced Beginner
Freeze more than just the top row, or first column
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

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
Reply With Quote
  #5  
Old 07-23-2013, 11:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Freeze more than just the top row, or first column Windows 7 64bit Freeze more than just the top row, or first column Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Slide Show freeze PPT 2010 bangonay PowerPoint 0 05-15-2012 01:38 AM
Freeze more than just the top row, or first column Possible to freeze both a column and a row? bryanarn Excel 2 03-11-2012 09:54 AM
Freeze more than just the top row, or first column How can I freeze a section (i.e. the side bar of a letterhead template) 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft