Numbering every second row

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

When i type 1 in the first cell and drag it down it creates a nice numbered
list. Is there a way to number only every second row?

Thanks,
Grant
 
Select the cell with 1 *and* the cell below it. Now fill down.

HTH
Jason
Atlanta, GA
 
Try this ..

Put in A1: 1, in A3: 2
Select A1:A4, fill down asdesired
(note that the selected range includes a 2nd blank cell, A4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top