Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sequenced numbering

Sequenced numbering

ResolvedVersion 2003

Thu 29 Jul 2010, 15:55 Delegate Janice said...

Janice has attended:
Excel Introduction course

Sequenced numbering

I have a column of numbers, i.e. 502, 503, 504 etc. What formula would I use for that column so that when I click in the next cell and drag the 'cross' downwards, the numbers will automatically increase. when I tried it, I got the same number each time and not the next one following.

Thu 29 Jul 2010, 16:37 Trainer Andrew said...

RE: sequenced numbering

Hi Janice

Thank you for your question. It may be that Excel is not able to confidently predict your sequence. You can help it by highlighting two values (e.g. 503 and 504) then using drag fill. This usually is enough to let Excel continue the sequence for you.

I hope this helps - let me know how you get on.

Kind regards,
Andrew

Thu 29 Jul 2010, 16:39 Delegate Janice said...

RE: sequenced numbering

Thanks, I'll give it a try.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips

Sequenced numbering

Sequenced numbering

RE: sequenced numbering

RE: sequenced numbering

Excel articles

Excel tip:

Use Paint Brush to Format More than one Cell