microsoft excel training courses london - Auto filter

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

Resolved · Low Priority · Version Standard

Auto filter

Richard has attended:
Excel Introduction course

by - delegate Richard [1 post] (2007 Feb 12 Mon, 16:22) Reply

how to get rid of auto filter buttons on my spread sheet

the auto filter will order alphabetically but only the one column. How do I get all the other colums (and data relevant to the cell which is moved) to move with the cell which is moved by the auto filter

thank you

Richard

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: auto filter

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 13 Tue, 12:23) Reply

Hi Richard,

To take the Autofilter off you can go into the Data menu down to Filter and where the AutoFilter has a tick on it you click on it and it will remove the filter.

The AutoFilter maintains the row order across the table, so when you order one column the rest should move with it. However if you highlight one column excel will only sort one column and leave the rest as they were.

Good luck

Tracy

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Advanced Excel Training - takes you to the next level
· Do You Really Need Excel VBA Training?
· How to Create Better Excel Spreadsheets: Part Four

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips