Microsoft Excel

How do you put a multiple filter in Microsoft Excel spreadsheet?

User Avatar
Wiki User
2010-07-15 15:20:08

It is not possible to have multiple autofilters in one

worksheet. What you can do is select your range(s) and convert them

to a list/table by going to Data->List in Excel 2003 or

Insert->Table in Excel 2007. This will give you the

functionality of an autofilter, but it can be applied to several

ranges within the same worksheet.


Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.