In Excel 2003, is there a way to keep, hold, lock the last row I have on page
1? I want to have the ability continue to add rows after that last row onto
the next page but keep the last row on page 1 exactly where it is.

Place a manual page break after the row in question.


Gord Dibben MS Excel MVP

On Mon, 25 Aug 2008 06:52:01 -0700, PJY
wrote:

In Excel 2003, is there a way to keep, hold, lock the last row I have on page
1? I want to have the ability continue to add rows after that last row onto
the next page but keep the last row on page 1 exactly where it is.

I tried that and if I need to add a row above, it still moves to next page -
but thanks for your help, anyway.

"Gord Dibben" wrote:

Place a manual page break after the row in question.


Gord Dibben MS Excel MVP

On Mon, 25 Aug 2008 06:52:01 -0700, PJY
wrote:

In Excel 2003, is there a way to keep, hold, lock the last row I have on page
1? I want to have the ability continue to add rows after that last row onto
the next page but keep the last row on page 1 exactly where it is.

You didn't ask for a row above!

You cannot freeze a row at the bottom of the sheet and enter rows above it.


Gord

On Mon, 25 Aug 2008 11:56:08 -0700, PJY
wrote:

I tried that and if I need to add a row above, it still moves to next page -
but thanks for your help, anyway.

"Gord Dibben" wrote:

Place a manual page break after the row in question.


Gord Dibben MS Excel MVP

On Mon, 25 Aug 2008 06:52:01 -0700, PJY
wrote:

In Excel 2003, is there a way to keep, hold, lock the last row I have on page
1? I want to have the ability continue to add rows after that last row onto
the next page but keep the last row on page 1 exactly where it is.