Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mac Auto-filter
I am trying to use auto-filter to select 20 Separate values on a sheet. I
know this can be done on a PC but can anyone tell me the best way to do this on a MAC? Maybe a bunch of macros? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mac Auto-filter
Hi,
If I understand your question you want to be able to pick 20 different items at the same time from an auto filter? If that is the case the answer is you can't do that on the PC, except in Excel 2007. So which version of the Mac Excel are you using, I will check if it can be done in 2008? Regardless of whether you can do it with AutoFilter you can do it with Advanced Filter - create a criteria area which includes the title of the column you want to filter on and the 20 items listed below it that you want to filter out. -- If this helps, please click the Yes button Cheers, Shane Devenshire "John" wrote: I am trying to use auto-filter to select 20 Separate values on a sheet. I know this can be done on a PC but can anyone tell me the best way to do this on a MAC? Maybe a bunch of macros? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |