Pasting columns but want the formulas to go up in increments of 1
 

I need to know how to copy numerous columns so I can paste them at the end,
(basically just expanding the worksheet to include more data) but I want the
formula in each cell for each subsequent column (in one row) to just go up by
1 each time.

For example if a cell's formula is C1+1, then the next cell is C1+2, then
the next cell is C1+3... How do I get that to continue when I paste in the
whole columns containing the C1+1, the C1+2, and the C1+3 cells in a row?...
+4, +5, and so on?

It's gotta be so simple that I just can't figure it out.

You can refer to the ROW in the formula with the ROW function that returns
the row number, e.g.

=C1+Row(C1)
copied down would be
=C2+Row(C2)
=C3+Row(C3)

and so on.

"Nicole L." wrote in message
...
I need to know how to copy numerous columns so I can paste them at the
end,
(basically just expanding the worksheet to include more data) but I want
the
formula in each cell for each subsequent column (in one row) to just go up
by
1 each time.

For example if a cell's formula is C1+1, then the next cell is C1+2, then
the next cell is C1+3... How do I get that to continue when I paste in the
whole columns containing the C1+1, the C1+2, and the C1+3 cells in a
row?...
+4, +5, and so on?

It's gotta be so simple that I just can't figure it out.