filter options missing

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

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

Filter options Missing

resolvedResolved · Urgent Priority · Version 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.


 

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips


Server loaded in 0.08 secs.