Auto copy of Numbers or date
 

I know how to put a number or date in a cell and then generate sequencial
numbers or dates in the following cells on a horizontal plain but is it
possible to say but the digit 1 in a cell and do the same for the vertical
plain so that I then have a whole column of sequential numbers going down the
sheet.

Any help would be apprecated.

Regards

Auto copy of Numbers or date
 

try this
write starting number in cell A1
then standing in cell A1
go to Edit | Fill | Series | And there you can select SERIES IN
Rows or Colums
of course specify Stop Value.

--
M.A.
"chesjak" wrote in message ...

I know how to put a number or date in a cell and then generate sequencial
numbers or dates in the following cells on a horizontal plain but is it
possible to say but the digit 1 in a cell and do the same for the vertical
plain so that I then have a whole column of sequential numbers going down the
sheet.

Any help would be apprecated.

Regards

Auto copy of Numbers or date
 

Hi Marijus
Thanks for the help. Just what I wanted.

"Marijus" wrote:

try this
write starting number in cell A1
then standing in cell A1
go to Edit | Fill | Series | And there you can select SERIES IN
Rows or Colums
of course specify Stop Value.

--
M.A.
"chesjak" wrote in message ...
I know how to put a number or date in a cell and then generate sequencial
numbers or dates in the following cells on a horizontal plain but is it
possible to say but the digit 1 in a cell and do the same for the vertical
plain so that I then have a whole column of sequential numbers going down the
sheet.

Any help would be apprecated.

Regards