Freeze Bottom Row

  • Thread starter Thread starter John Persico
  • Start date Start date
J

John Persico

Is there a way to freeze the bottom row? I have a spreadsheet with 221
rows. In the 222 row I run totals. Can I have row 222 frozen, so that
whereever I'm in the spreadsheet it shows. I have the top row (titles)
frozen.

--
 
Why not put the Totals at the top of the list under the title row and
then Freeze Panes under the Total Line?

i.e
Row1 Title row
Row2 Total row
Freeze Panes
Row3...data to sum
 
I know this might sound like a silly question, but...
How do you freeze multiple rows? I see an option to freeze the top row and
to freeze the first colomn.
 
Select the row beneath the one where you want the bottom of the freeze
section. Click on Window/Freeze Panes.

Craig
 
You will get much better answers when you identify your version of Excel
right from the start. As you can see, you severely limit your audience when
you ask everyone else to do all of the work, and you're not willing to do
any.

In 2007, it's View>Freeze Panes

Regards,
Fred
 
But you could find "freeze panes" in help if you cared to.

I will never understand why it seems simpler to post and wait for a reply
rather than use Excel help.


Gord Dibben MS Excel MVP
 
That's not correct.

The procedure is:
Highlight cell A3
View>Freeze Panes>Freeze Panes

Now your top two rows are frozen.

Fred.
 
A teacher I know like to say that there are no stupid questions, but there
are plenty of lazy questions. :)
 
Back
Top