anything in Excel...

It's Excel-o-lozy...

How to apply more than one Auto filter on different data ranges in an Excel Sheet?

Excelolozy.com - Applying auto filter on a database in a sheet is pretty simple. But how to apply autofilter if there are two different set of database tables in a sheet?

It's simple. Select the first data range.
Go to > Home > Styles > Format as table.
Then select the second Data rage and do the same there too. Now you can apply filter on these two data ranges separately.

Apply more than 2 auto filters in a sheet at #Excelolozy by Vikrmn CA Vikam Verma
Apply more than 2 auto filters in a sheet at #Excelolozy by Vikrmn CA Vikam Verma

Moreover any number of data ranges can be set as a table in a worksheet and thus auto filter be applied separately on all of these.

How to apply filter in single click shortcut of three buttons.. Read here..

Anything in Excel, be an Excelolozian...
for best MS Excel Tips visit http://www.Excelolozy.com
Gotta query??? Drop a mail at mail@excelolozy.com
Posted by Vikrmn: Author of "10 Alone" (CA Vikram Verma) 10Alone.com

0 comments: