training microsoft excel - Excel formatting/Formular

Resolved · Low Priority · Version Standard

Excel formatting/Formular

Mailin has attended:
Excel Intermediate course

by - delegate Mailin [2 posts] (2007 Aug 2 Thu, 15:10) Reply

What can I do if my drop-down arrows don't include all information I want to see on my atuo-filter?

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 formatting/Formular

by - trainer Amanda diamond contributer [1208 posts] (2007 Aug 3 Fri, 12:43) Reply

Hi Mailin

Thank you for your question.

The dropdown arrows for the autofilter will show each unique item in the column below.

If not all of the items in the column show in the dropdown list, it might be because there is a blank row or rows that occurs somewhere in the list area.

Otherwise if you are meaning that you want to be able to filter for more than one item in the column, you can use the Custom option in the dropdown list to do this.

Amanda

RE: Excel formatting/Formular

by - delegate Mailin [2 posts] (2007 Aug 3 Fri, 15:21) Reply

Brilliant, thanks very much for your quick reply! So all I need to do is avoiding blank rows on the spread sheet.
Luckily i have learnt about the Custom option yesterday on the course.
thanks again
Mailin

RE: Excel formatting/Formular

by - trainer Amanda diamond contributer [1208 posts] (2007 Aug 3 Fri, 16:49) Reply

Hi Mailin

Good to hear there was a quick resolution to your problem.

Generally with a list it is best to make sure there are no blank rows, as this will affect sorting as well and also pivot tables if you use them.

Amanda

· Microsoft Excel Training: Not Just for Newbies Anymore
· Prepare for your MOS Certification with MS Excel Courses
· Do You Really Need Excel VBA Training?
· MS Excel: Excel At Making The Most Of Your Christmas
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips