Can anyone help?

[Bonehead]

Can anyone tell me how to do this as I am rubbish with excel.

What I want to do is type in "A1" in a cell and the next cell to
automatically write "A2" and so on. How do I do this please you clever
clever people.

Thanks

Nath

 

[Dave Peterson]

Not quite automatic, but how about typing A1 and rightclicking on the autofill
button at the bottom right corner and dragging to the right.

When you let go, choose Fill Series.

 

[Debra Dalgleish]

Or, point to the fill handle, hold the left button, and drag to the right.

There's a picture of the fill handle here:

http://www.contextures.com/xlDataEntry01.html#Mouse