Excel for Mac 2011 / OS X: Where's the Filter by Form functionality?
Hi all
20+ year Excel on a PC user, 20+ minutes Excel on a Mac user.
Where's the 'Filter by Form' function?
When I go to Data ribbon > Filter... ribbon item > By cell value, and then click on any of the column dropdowns, it seems to be filtering on Color and not on Value, and I don't know how to change it to value.
Thanks.
Jim
20+ year Excel on a PC user, 20+ minutes Excel on a Mac user.
Where's the 'Filter by Form' function?
When I go to Data ribbon > Filter... ribbon item > By cell value, and then click on any of the column dropdowns, it seems to be filtering on Color and not on Value, and I don't know how to change it to value.
Thanks.
Jim
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Jim
It works for me, I cannot replicate the problem however I do note that the pop-up dialog which appears always makes reference to COLOR even though it IS using the text value.
It works for me, I cannot replicate the problem however I do note that the pop-up dialog which appears always makes reference to COLOR even though it IS using the text value.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER