use autofill on next cell in row using formula of the cell above

%3CLINGO-SUB%20id%3D%22lingo-sub-2740826%22%20slang%3D%22en-US%22%3Euse%20autofill%20on%20next%20cell%20in%20row%20using%20formula%20of%20the%20cell%20above%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2740826%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20applying%20this%20formula%20in%20the%20first%20cell%20in%20the%20row%20'A2'%20%3A%26nbsp%3B%3D%22SB-%22%26amp%3BTEXT(ROWS(A%242%3AA2)%2C%220000%22).%3C%2FP%3E%3CP%3EIt%20should%20export%20this%20%3A%20SB-001.%3C%2FP%3E%3CP%3EIn%20the%20next%20cell%26nbsp%3B(in%20the%20same%20column%20in%20the%20next%20row)%20it%20will%20generate%3A%20SB-002%3C%2FP%3E%3CP%3Ehow%20to%20fill%20out%20the%20next%20cell%20(%20in%20the%20same%20column%20in%20the%20next%20row)%20automatically%2C%20without%20using%20the%20fill%20handler%20to%20pull%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2740826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I am applying this formula in the first cell in the row 'A2' : ="SB-"&TEXT(ROWS(A$2:A2),"0000").

It should export this : SB-001.

In the next cell (in the same column in the next row) it will generate: SB-002

how to fill out the next cell ( in the same column in the next row) automatically, without using the fill handler to pull it down.

1 Reply

@kishta 

If you are on Excel 365 you may use something like

="SB-"&TEXT(SEQUENCE(100),"0000")

If not, put your formula in A2, enter into name box A2:A100 (or so), range will be selected, Ctrl+D