Ask Your Question
0

enter a number series in spreadsheet

asked 2018-12-12 16:03:53 +0100

jtwright gravatar image

I need to fill a column from 1 to end (140) with sereal numbers I cannot find the function

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-12-12 23:36:32 +0100

Ratslinger gravatar image

updated 2018-12-12 23:37:06 +0100

Hello,

Enter 1 in cell where you want to start:

image description

Using your left mouse button, click the handle in lower right corner of selected cell, hold the button down & drag down 140 rows. Then release the button giving:

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-12 16:03:53 +0100

Seen: 24 times

Last updated: Dec 12 '18