Incrementing Large Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that you can increment values in a column by entering a few values,
selecting them and then dragging the lower-right edge down the column. But
what if you want to do this for thousands of rows?

Is there some shortcut or function that you can use to get say rows 1 to
5,000 incremented by 1 each?

Thanks,

Steve
 
enter the 1st number in row 1 and highlight that number
Edit > Fill > Series > Series in select Columns > Step Value: 1 > Stop
value: 5000 > OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incrementing Large Ranges 5
Auto number Non null values 6
auto number 3
increment cells in repeating formulas by something other than 1 8
Drag without incrementing 2
Formula results display only after pressing Enter key 1
Changing the incrementation when "puliing" cell values down a colu 4
Row increments - 7

Back
Top