Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2013, 08:44 PM
officeboy09 officeboy09 is offline How do I frozen a certain part of a worksheet? Windows XP How do I frozen a certain part of a worksheet? Office 2003
Advanced Beginner
How do I frozen a certain part of a worksheet?
 
Join Date: Oct 2013
Location: Australia
Posts: 40
officeboy09 is on a distinguished road
Default How do I frozen a certain part of a worksheet?


Hi,
I'd like to frozen or lock up some particular rows on a worksheet so that wherever I scroll on that worksheet, the frozen rows remain in their positions.
I remember it should be a selectable feature under the tools menu, but now I forgot excatly how it was done before.
Does this function also apply to locking up a specific area confined by a certain number of row and column?
Reply With Quote
  #2  
Old 12-09-2013, 09:43 AM
jolivanes jolivanes is offline How do I frozen a certain part of a worksheet? Windows XP How do I frozen a certain part of a worksheet? Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 93
jolivanes will become famous soon enough
Default

In 2003 it is under Window - Freeze Panes
Reply With Quote
  #3  
Old 12-10-2013, 10:53 AM
BobBridges's Avatar
BobBridges BobBridges is offline How do I frozen a certain part of a worksheet? Windows 7 64bit How do I frozen a certain part of a worksheet? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 695
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Officeboy, you can't freeze just any rows or columns; but you can freeze the top rows and the left columns. I don't know what version of Excel you're using, but in Excel 10 you start with the ribbon's View tab, then look for the Freeze Panes option.

I don't know what you mean by your second question...?
Reply With Quote
  #4  
Old 12-13-2013, 06:26 PM
officeboy09 officeboy09 is offline How do I frozen a certain part of a worksheet? Windows XP How do I frozen a certain part of a worksheet? Office 2003
Advanced Beginner
How do I frozen a certain part of a worksheet?
 
Join Date: Oct 2013
Location: Australia
Posts: 40
officeboy09 is on a distinguished road
Default

Quote:
Originally Posted by BobBridges View Post
Officeboy, you can't freeze just any rows or columns; but you can freeze the top rows and the left columns. I don't know what version of Excel you're using, but in Excel 10 you start with the ribbon's View tab, then look for the Freeze Panes option.

I don't know what you mean by your second question...?
The 2nd question means that if I have a set of data in an area, say B44-F56, is there a way to freeze it so that whenever I scroll above or below or on the left or right of that area, it remains static.

But from your reply, I guess only the uppermost or the part furtherest to the left in a worksheet can be frozen.
Reply With Quote
  #5  
Old 12-13-2013, 07:46 PM
BobBridges's Avatar
BobBridges BobBridges is offline How do I frozen a certain part of a worksheet? Windows 7 64bit How do I frozen a certain part of a worksheet? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 695
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

That's my belief, yes. Now, there is something else you can do that may satisfy your needs: You can split the display into vertically and/or horizontally, and scroll to a different part of the worksheet in the top/bottom or left/right portions of the screen. This would allow you to examine in one glance, say, columns A:D and X:Z, and/or rows 1:20 and 1029:135. This isn't permanent; unlike freezing the top (header) rows and left columns you can always scroll to different parts of the worksheet. But if what you want is a temporary effect, it would probably be useful for you. And it is saved from one Excel session to the next; I have one workbook where I do it often, and it remembers the split-screen settings when I open the workbook a few weeks later. If you want to look into that, look for Split in the ribbon's View tab.
Reply With Quote
  #6  
Old 12-15-2013, 10:15 PM
macropod's Avatar
macropod macropod is offline How do I frozen a certain part of a worksheet? Windows 7 32bit How do I frozen a certain part of a worksheet? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,927
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In any version of Excel, you can scroll the worksheet so that the top-left corner of the area you wan to view is at the top-left corner of the active window. You can then click on another cell and use Freeze Panes to 'lock' the screen such that the area bounded by the top-left corner of the active window and the 'other' cell cannot be scrolled out of view. You also have the 'Split' option, which allows you to scroll each of the windows independently.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I frozen a certain part of a worksheet? Document Folder dialog box frozen detobias Word 1 11-03-2013 04:43 PM
How to Rename a Quick Part sleake Word 14 10-14-2013 09:21 AM
How do I frozen a certain part of a worksheet? How to summarise different worksheet to a summary worksheet samkiewhock Excel 1 09-06-2012 03:34 AM
Word 2000 frozen, then not working even after re-install kpankulu Word 8 05-25-2012 03:44 AM
How do I frozen a certain part of a worksheet? "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:24 PM.


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