Numbered steps

C

chowgirl

Something is staring me in the face but I'm not seeing it.

All I want to do is create cells with "Step 1, "Step 2," Step 3," etc.,
with automatic sequencing of the Steps and automatic (if possible)
entry of the word "Step." I can do it in Word, but in Excel I can't
figure out how to concatenate or use some Custom Number format or
whatever it is I need to do.

Thanks for helping Miss Brainfry here.
 
C

chowgirl

I entered "1" in the first cell, with Number format "Step "#, then
summed the succeeding cells and applied the same format.
 
K

Ken Wright

You could also have just put Step 1 in cell A1, Step 2 in cell A2, selected
both cells, and then clicked on the little black cross at the bottom right of
your selectiona nd dragged down.

You could also have put in cell A1 the formula ="STEP "&ROW() and copied
down (albeit the numbers would change if you added/deleted rows above your
data.

One advantage of the method you actually used is that your data remains
numeric, and sometimes this can be useful too.
 
Top