Autofilter in a single cell
 

I want to activate the autofilter in a single column, and not in all
columns in the same row. Can I do that?


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=554082

Autofilter in a single cell
 

It appears that you can insert a blank column on either side of the one you
want to filter (or just to the right if your column is the first column (A),
put on the filter and then delete or hide the blank columns.

"Turquoise_dax" wrote:


I want to activate the autofilter in a single column, and not in all
columns in the same row. Can I do that?


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=554082

Autofilter in a single cell
 

Click the button at the top of the column that you want to AutoFilter
Choose DataFilterAutoFilter
Only that column will have an AutoFilter dropdown arrow in its heading

However, when you filter on that column, entire rows will be hidden, so
data in other columns will be hidden too.

Turquoise_dax wrote:
I want to activate the autofilter in a single column, and not in all
columns in the same row. Can I do that?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html