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

filter options missing

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Filter options Missing

Filter options Missing

ResolvedVersion 365

Fleur has attended:
Excel Intermediate course
Excel Introduction course

Filter options Missing

When adding more options to a 'picklist' on a filter tab, when i go back to the filter on the main spreadsheet, the picklist options which I inputted don't appear?

For context, I have recently updated a picklist, to include more names. When I go onto pick from the filter, some names are missing?

RE: Filter options Missing

Hello Fleur,

Thank you for your question.

Can I please just check that I understand correctly. By 'picklist', are you referring to a drop-down list created with the Data Validation tool?

Kind regards
Marius Barnard
STL

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 18 Jan 2024: Automatically marked as resolved.

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

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.