Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incrementing Large Ranges
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Incrementing Large Ranges
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 "Steve in S.F." wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incrementing Large Ranges | Excel Discussion (Misc queries) | |||
incrementing | Excel Discussion (Misc queries) | |||
sorting and incrementing down | Excel Discussion (Misc queries) | |||
Incrementing by 1 when doc is opened | Excel Worksheet Functions | |||
Automatic incrementing | Setting up and Configuration of Excel |