Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

training microsoft excel - excel formattingformular

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Excel formatting/Formular

training microsoft excel - Excel formatting/Formular

ResolvedVersion Standard

Mailin has attended:
Excel Intermediate course

Excel formatting/Formular

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

RE: Excel formatting/Formular

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

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

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

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.



Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.



To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.