Ask Your Question

how to increase value in successive cells by one

asked 2019-11-07 03:34:05 +0100

officegeek gravatar image

in successive rows in a column of spreadsheet spreadsheet

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-11-07 04:38:18 +0100

Aging Cannon gravatar image

For example:

Insert the number 1 into cell A1. Insert the formula =A1+1 into cell B1. Copy that formula to additional columns as needed.

That's the simplest way.

edit flag offensive delete link more


Or you could use the handle on the bottom right of the cell to drag down as far as you need. Play with it with values and formulae to see what can be done.

robleyd gravatar imagerobleyd ( 2019-11-07 08:17:51 +0100 )edit

Or one could use Sheet->Fill Cells->Fill Series :-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-11-07 08:46:29 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-07 03:34:05 +0100

Seen: 32 times

Last updated: Nov 07