Freeze Bottom Row

[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.

--

 

[CB]

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

 

[John Persico]

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.

 

[Craig Schiller]

Select the row beneath the one where you want the bottom of the freeze
section. Click on Window/Freeze Panes.

Craig

 

[John Persico]

I can't find a Window, Freeze Pane in Excel 2007.

 

[Fred Smith]

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

 

[Gord Dibben]

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

 

[John Persico]

That only freezes the top row.
I was trying to freeze any row.

 

[Fred Smith]

That's not correct.

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

Now your top two rows are frozen.

Fred.

 

[Lewis Clark]

A teacher I know like to say that there are no stupid questions, but there
are plenty of lazy questions.