Adding additional rows for data entry

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a spreadsheet with five columns that I enter data to. I then
have a blank row at the bottom of these columns. Below the blank row I
have several formulas pertaining to each row. How do I add more data
to the columns and have the formulas adjust for these new rows without
highlighting rows and using the insert rows command to make room (empty
rows) where I can then add the additional data to the columns. Is
there a formula that would always leave one empty row even when new
data is entered in the columns?

Thanks
 
Put the formulas at the top of the columns. You can even use a Freeze Pane
just below the formula row so that the results of the formulas will always
be visible when you scroll down the page.

Biff
 
You must log in or register to reply here.

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

Excel Help to copy information from one row at a time to another sheet 1
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
automatically numbering rows 2
adding rows into the table 1
Finding Last Entry in a Column 1
Figuring out a lengthy formula. Probably quite simple... 3
Pull a column header from a row of numbers 1
Looking for the value that indicates last row number that has filled cells 3

Back
Top