Newsgroups: microsoft.public.excel.worksheet.functions
From: "Ragdyer" <RAGD...@MSN.COM>
Date: Mon, 15 Jul 2002 09:40:47 -0700
Local: Mon, Jul 15 2002 12:40 pm
Subject: Re: Permanent Row's that do not scroll
Use "Freeze Panes".
Try to think of the FreezePanes command as creating a picture frame around The main rule to remember in using the FreezePanes command is: The next rule to remember is that: Never select A1 or the cell in the A1 position in any screen view. It'll In the normal WS view, if you select B1 and invoke FreezePanes (FP), If you had selected A2, everything above (all of row 1) and to the left If you had selected B2, everything above (all of row 1) and to the left (all Just keep in mind that the selected cell at the time of the FP command is If your WS should happen to have a logo or a letterhead with addresses and Scroll your WS so that cell C15 is in the A1 position in your screen view. This should give you a little more insight into FreezePanes. HTH RD > Can someone tell me how to have a row at the top of my
> spreadsheet that will not scroll down with the other rows. > I have seen this before but can not figure out how to have > it on my spreadsheets. > Anne You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||