AutoFilter

ammdumas · Mar 15th, 2002, 04:15 PM

How do I get Autofilter to work for only one column (not all of them)?
Can I hide the arrow that come with it?
(I only need it for a print range)

Al Chara · Mar 15th, 2002, 04:19 PM

If you insert a blank column between the two columns with data and then select the first column; you can have the autofilter only on the first column.

Chris Davison · Mar 15th, 2002, 04:22 PM

clear your autofilter

if your headings are in row 1 :

pop your cursor on the column character to highlight the entire column (ie column B)

then click autofilter

if not :

click your column header and select down the whole range and then click autofilter

ammdumas · Mar 15th, 2002, 08:25 PM

Thanks.
I figured it had to be something simple.

Mar 15th, 2002, 04:22 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	clear your autofilter if your headings are in row 1 : pop your cursor on the column character to highlight the entire column (ie column B) then click autofilter if not : click your column header and select down the whole range and then click autofilter __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 04:15 PM	#1
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	How do I get Autofilter to work for only one column (not all of them)? Can I hide the arrow that come with it? (I only need it for a print range)

Mar 15th, 2002, 04:19 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	If you insert a blank column between the two columns with data and then select the first column; you can have the autofilter only on the first column.

Mar 15th, 2002, 08:25 PM	#4
ammdumas Board Regular Join Date: Mar 2002 Location: Waterdown, Ontario Posts: 444	Thanks. I figured it had to be something simple.