Keeping last row last

  • Thread starter Thread starter PJY
  • Start date Start date
P

PJY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Countif wrong in last row or two 3
Keeping bottom rows on page one 1
the Last occurance 3
Linking 2 spreadsheet using data from the last row of spreadsheet 13
Copy and paste to the last row 3
VBA selction of rows using a variable 5
Row - 1 in vba 2

Back
Top