HAVING TROUBLE KEEPING MY SPREADSHEET FORMULAS PERMANENT

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Using Excel 2003, I have developed a spreadsheet that I am constantly adding
to. I am happy with all the formulas and values that I have established on
it. However, it seems that I have to constantly edit the cell values, insert
the formula, etc. every time I add another row. What is the best way to
maintain the consistency on a spreadsheet that I am constantly adding to?
Thanks!!
 
As always post yours for comments. However, you may just need to have a
dummy row at the bottom and insert BEFORE that row OR use a defined name
such as =offset($a$2,0,0,counta($a:$a)-1,1)
 

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

Formula's in linking spreadsheets 1
Running formula 4
Excel Excel Formula OFFSET maybe? 1
f4 to make constant 5
formula bar on at all times 1
Excel won't resolve formula in one column 3
Formula Assistance 7
Keeping cell references constant 1

Back
Top