Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2014, 05:56 PM
markg2 markg2 is offline Freeze more than 2 rows? Windows 7 Freeze more than 2 rows? Office 2007
Expert
Freeze more than 2 rows?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Freeze more than 2 rows?

If you do not choose to select freeze columns AND rows, and you choose to freeze, for example, just the top 3 rows and no columns, Excel will only freeze 1 of the 3 rows.

This makes zero sense so I'm wondering if there's something I'm missing.
Reply With Quote
  #2  
Old 09-01-2014, 07:42 PM
jolivanes jolivanes is offline Freeze more than 2 rows? Windows XP Freeze more than 2 rows? Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default

Select Cell A4
View - Freeze Panes - Freeze Panes (Top of 3 possibilities)

This works for me. Leaves the top three rows "frozen".
Reply With Quote
  #3  
Old 09-02-2014, 05:52 AM
markg2 markg2 is offline Freeze more than 2 rows? Windows 7 Freeze more than 2 rows? Office 2007
Expert
Freeze more than 2 rows?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

Yep--that works. But isn't it strange that freeze panes doesn't overtly allow selecting multiple rows in a normal, straightforward manner (selecting row 1,2,etc).

Mark
Reply With Quote
  #4  
Old 09-02-2014, 08:46 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Freeze more than 2 rows? Windows 7 64bit Freeze more than 2 rows? 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

If you want to freeze say the 250000 first rows, it seems easier to me to select cell A250001 ( F5 - Goto) and then freezing, then trying to select 250000 rows...
__________________
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Freeze more than 2 rows? Grouping table rows to prevent individual rows from breaking across pages dennist77 Word 1 10-29-2013 11:39 PM
Freeze more than just the top row, or first column Gary Drumm Excel 4 07-23-2013 11:34 AM
Freeze more than 2 rows? Possible to freeze both a column and a row? bryanarn Excel 2 03-11-2012 09:54 AM
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 08:05 PM.


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