Hello-
Let's say you want to start in cell A5 starting with 100:
Option 1-
In cell A5 type 100
In cell A6 type 101
Select A5 & A6
Use the Fill Handle (lower right corner of cell selector) to drag as far
down the column as necessary.
Option 2-
In cell A5 type 100 & click the green check on the editing bar (or press
Ctrl+Enter to enter the value but keep cell selector on A5)
Go to Edit>Fill>Series, click the Option for Columns & make sure Linear is
set under Type.
Type in the value you want to end with into the StOp Value field (not the
StEp Value), then click OK.
HTH |:>)
"Amateur" wrote:
> I need to number a sheet sequentially, in one column, starting with a number
> of my choice. How do I make it so I only have to fill in the first couple?
Bookmarks