#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
In 2003 it is under Window - Freeze Panes
|
#3
|
||||
|
||||
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...? |
#4
|
|||
|
|||
Quote:
But from your reply, I guess only the uppermost or the part furtherest to the left in a worksheet can be frozen. |
#5
|
||||
|
||||
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.
|
#6
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 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 |
"Auto-populating" data-worksheet to worksheet. | meggenm | Excel | 4 | 02-04-2012 02:04 AM |