Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto enter sequential numbers into cells without 'pulling' handle 4

Status
Not open for further replies.

bazil2

Technical User
Feb 15, 2010
148
DE
(elementary user)

My goal is to automatically enter values into a spread sheet that increment by the value of '1'.

Cell A1 should have the value '1' and cell A6000 should have the value '6000'; the cells in between should increment by '1'

Can this be done without pulling on the little tab?

Many thanks for any advice.
 
Fill : Series

It's in different places in different versions.
 
hi,

"automatic"
"without pulling the little handle"

Well how do you propose that the "automatic" knows to stop at row 6000?

Please describe the PROCESS, not the Excel features, which you propose to occur to get from no numbers to 6000? Like...
[tt]
1. open a new workbook
2. then what?
[/tt]


Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
If you don't want to fill the series with genuine values using the handle on the corner and Fill-Series, there are oodles of ways to get a set of cells containing sequential numbers using formulae.

My usual is to put =A1+1 in A2, and then copy down as far as I need. This has an application if your series will have occasional breaks, in that you can just put a new number on any line, and it will continue down from the new start-value.

=row() or =row(A1) copied down will also create a series, but without the chance to restart on a different value.
 
A keyboard way... copy the cell that has the formula. Press the F5 key, enter the range such as A3:A6000 click ok or press enter and then press enter again. All those cells will now have the formula. If you then want them to be numbers, press F5 and enter the range again, then copy, paste special values.
 
Thank you so much for all of your suggestions; I had no idea there were so many ways of going about this.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top