Ask Your Question

enter a number series in spreadsheet

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

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

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

Ratslinger gravatar image

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


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


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

Seen: 149 times

Last updated: Dec 12 '18