|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
*NEVER* invoke "Freeze Panes" when the cell in the "A1 Position" is
selected.
Picture a newly opened sheet.
The top, left cell is A1.
Click in A6, then,
<Window> <Freeze Panes>
You'll see that rows 1 to 5 are frozen ... all well and good!
Now, unfreeze them:
<Window> <Unfreeze Panes>
Click in A6.
Using the scroll bar on the right, scroll down 5 rows so that A6 is in the
"A1 Position" (top left).
Then:
<Window> <Freeze Panes>
You see what happens?
That's probably your problem.
Unfreeze the panes.
With A6 in the "A1 Position", click in A7, then freeze panes.
All should be OK now, *BUT* you'll notice that you *can't* display above Row
6.
This is a good procedure to keep headers and/or logos hidden so that more
screen real estate can be utilized,
And at the same time, *allows* these rows to still print (truly hidden rows
*don't* print).
Don't forget ... *never* invoke Freeze Panes when the cell in the A1 screen
position is selected!
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"lexiacsi" <lexiacsi@discussions.microsoft.com> wrote in message
news:EF11866B-38E5-46CC-83D7-CCD868BAE9C1@microsoft.com...
>
>
> "Gord Dibben" wrote:
>
> > The rule for freezing panes is.....
> >
> > Columns to left of and rows above the selected cell will be frozen.
> >
> > Do not select row 1 to freeze row 1. As you have seen, it will freeze
panes
> > in mid-window.
> >
> > Select A2 to freeze row 1
> >
> > Select B2 to freeze row 1 and column A
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Wed, 30 Mar 2005 13:59:05 -0800, emilyp
<emilyp@discussions.microsoft.com>
> > wrote:
> >
> > >I've tried highlighting the row I would like to freeze, usually just
the
> > >first row, but it always freezes it after the 16th row. Any
suggestions!?
> > >This is really frustrating!
> >
> >
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
Question
Answer
Notify me of replies