formulas: adding columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Two ways...
1. Always insert new columns and rows BEFORE the last
used column or row, or (if new rows/columns must always be
added at the end)

2. Always insulate your data with a final blank row and
blank column. Add new rows/columns just before the blank
row/column.

Hope this helps.
-----Original Message-----
I have a spreadsheet that will total across the rows and
Click to expand...
down the columns. How do I create the "total" formulas to
automatically include any new columns/rows that I insert?
 
That did help, but I have formulas within the columns that previously existed. Will have to copy the formulas to the new columns? Is there a way I can write a formula so that any new columns that are inserted will contain a specific formula that occurs in all cells in a range across a row?

Let's say cell h6 contains "sumh3:h5" and the other cells in the 6 th row of the worksheet contain the same formula for the applicable column/row references. If I insert a new column, say R, the formula does not automatically get inserted in R6 even if the column R is sandwiched by columns that contain the same formula in their appropriate 6th row. How do I create the formula to automatically insert a formula to all cell references when a new column is inserted?
 
Back
Top