Using filler handles

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

Resolved · Low Priority · Version 2003

Jo has attended:
Excel Introduction course

by - delegate Jo [1 post] (2008 May 7 Wed, 16:37) Reply

How do you put it in dates in order for a table?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 19 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 20 Tue	Tooting	0	FULL
2003/XP	2008 May 20 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 May 22 Thu	Bloomsbury	7	book now	£188	£215
2003/XP	2008 May 29 Thu	Southwark	4	book now	£207	£215
2003/XP	2008 Jun 3 Tue	Bayswater	5	book now	£198	£215
Full Schedule: See all 169 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Using filler handles

by - trainer Tracy platinum contributer [586 posts] (2008 May 7 Wed, 20:05) Reply

If the dates are in a column you can simply put your active cell in a date cell and click on the ascending or decending button (A>Z or Z>A) depending on which you want.

Good luck

Tracy

· Basic Excel Training
· How to Create Better Excel Spreadsheets: Part Two
· Microsoft Excel Training: Essential for Today's Employees
· MS Excel: Excel At Making The Most Of Your Christmas
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Printing spreadsheets without opening them first

Here's a fast way of printing a spreadsheet from Windows Explorer/My Computer.

Go to the location where the spreadsheet is saved on your computer, then right-click on the icon next to the document and select Print from the menu.

The spreadsheet will automatically open, print and close itself.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Using filler handles

Related articles

Excel tip:

Printing spreadsheets without opening them first