How to select preceeding cell in a formula?

I need to replicate a formula down a column, where each cell is the value of
the preceeding cell (directly above it) + 1. I have no idea how to do this,
being new to Excel. Any ideas would be really helpful.

Thanks!

Nel post news:[email protected]
*Dennis* ha scritto:

> I need to replicate a formula down a column, where each cell is the
> value of the preceeding cell (directly above it) + 1. I have no idea
> how to do this, being new to Excel. Any ideas would be really helpful.
>
> Thanks!

In A3 put:

=A2+1 and copy down...


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy

Hi Dennis,

assuming you will do it on the D column

on cell D1 type 1
on cell D2 use the formula =d1+1

and copy it down

HTH
Regards from Brazil
Marcelo

"Dennis" escreveu:

> I need to replicate a formula down a column, where each cell is the value of
> the preceeding cell (directly above it) + 1. I have no idea how to do this,
> being new to Excel. Any ideas would be really helpful.
>
> Thanks!