Inserting series every 4th cell?

  • Thread starter Thread starter Grativo
  • Start date Start date
G

Grativo

I'm trying to label cells, B001...B002...B003, etc on a column, but I need to
do this every 4th cell. What's the best way to do this? Thanks in advance for
any help.

Grativo
 
Easiest way is probably to put B001 in a cell, leave 2 cells and in the 4th
put B002,
now if you started in A1 with B001 and B002 is in A4, select A1:A6, grab a
hold in the corner of A6 and copy down as long as you need
 
Back
Top