autofilter on many columns
I have been given a spreadsheet which has autofilter on many columns. I
can only manage to put it on one column at a time. Could someone tell me how to autofilter more than one column at a time. Thanks Chris |
autofilter on many columns
Hi, Try using Advance Filter. See attached for instructions http://www.contextures.com/xladvfilter01.html -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561697 |
autofilter on many columns
Remove the filter arrows (data|filter|autofilter)
Then select the whole range--last header row to the bottom row and include all the columns you want filtered. Then do data|Filter|autofilter. inquirer wrote: I have been given a spreadsheet which has autofilter on many columns. I can only manage to put it on one column at a time. Could someone tell me how to autofilter more than one column at a time. Thanks Chris -- Dave Peterson |
autofilter on many columns
Dave Peterson wrote:
Remove the filter arrows (data|filter|autofilter) Then select the whole range--last header row to the bottom row and include all the columns you want filtered. Then do data|Filter|autofilter. inquirer wrote: I have been given a spreadsheet which has autofilter on many columns. I can only manage to put it on one column at a time. Could someone tell me how to autofilter more than one column at a time. Thanks Chris Thank you that is what I wanted |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com