Account Options

  1. Sign in
The old Google Groups will be going away soon.
Switch to the new Google Groups.
Google Groups Home
« Groups Home
Message from discussion Permanent Row's that do not scroll
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Ragdyer  
View profile  
 More options Jul 15 2002, 12:46 pm
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
your WS that only has a top and/or left side.  The WS (picture) can scroll
up or down or left or right, but the frame remains static (frozen).

The main rule to remember in using the FreezePanes command is:
Everything above and to the left of the selected cell will become static
(frozen - the picture frame).

The next rule to remember is that:
What "exactly" (rows and/or columns) becomes static depends on the screen
view at the time of the instigation of the FreezePanes command.

Never select A1 or the cell in the A1 position in any screen view.  It'll
just confuse you (selects the cell in the middle of the screen view).

In the normal WS view, if you select B1 and invoke FreezePanes (FP),
everything above (nothing in this case) and to the left (all of column A)
will be frozen.

If you had selected A2, everything above (all of row 1) and to the left
(nothing in this case) would have been frozen.

If you had selected B2, everything above (all of row 1) and to the left (all
of column A) would become static.

Just keep in mind that the selected cell at the time of the FP command is
the top left corner of your picture.
The use of <Ctrl> + <Home> will always take you to the selected, corner
cell.

If your WS should happen to have a logo or a letterhead with addresses and
phone numbers that take up valuable screen space, you could simply exclude
them from the screen view without excluding them from the print area by
using the FP command.

Scroll your WS so that cell C15 is in the A1 position in your screen view.
Now select cell D17 and invoke FP.
Everything above and to the left of your screen view at the time of the
instigation of the FP command is now excluded from view.  You cannot scroll
to them.
They can still be in your print area (unlike hidden cells).
The only way to view them is to "UnfreezePanes".

This should give you a little more insight into FreezePanes.

HTH

RD

"Anne" <DJe...@aol.com> wrote in message

news:19ea801c22c1b$c6f4b420$35ef2ecf@TKMSFTNGXA11...
> 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
> DJe...@aol.com


 
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.