microsoft excel training class - excel - how do you get consecutive numbers

The UK's most regular instructor-led training courses.
Training information: microsoft excel training class · Excel in courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

excel - how do you get consecutive numbers

Simon has attended:
Excel Introduction course
Excel Intermediate course
Excel Introduction course

by - delegate Simon [2 posts] (2007 Aug 20 Mon, 14:09) Reply

ie years down a column ?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: excel - how do you get consecutive numbers

by - trainer Richard platinum contributer [813 posts] (2007 Aug 20 Mon, 15:35) Reply

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

RE: excel - how do you get consecutive numbers

by - delegate Simon [2 posts] (2007 Aug 21 Tue, 07:29) Reply

many thx

· Reasons Why VBA for Excel Training Fails
· Customized Financial Excel Courses in London
· Compare Different MS Excel Training Methods
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Training Budgets In A Bad Economy