Mon 20 Aug 2007, 14:09Delegate Simon said...
Simon has attended:
Excel Introduction course
Excel Intermediate course
Excel Introduction course
excel - how do you get consecutive numbers
ie years down a column ?
Mon 20 Aug 2007, 15:35Trainer Richard said...
RE: excel - how do you get consecutive numbers
Hi Simon
You can use the FILL SERIES function to create this.
Start the process by entering the starting year in the first cell.
Then go down one cell , andenter the next year.
Now, select BOTH cells, and then draw the solid black square in the bottom right corner of the selection DOWNWARDS, until you get to the number that you require.
Regards
Richard
