filter only one column

L

LMD

I want to filter only one column in my spreadsheet. I can seem to only
filter all the columns in a row by going to Data, Filter, autofilter. But
this makes me filter all the columns. I just want to filter one specific
column so I don't see the filters on the other columns. Can I do this??
 
D

Dave Peterson

Select the range you want to filter--not just a single cell.

Then apply data|filter|autofilter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy mailflow when emails sent to specific IP 0
Dates In Excel 5
Need Help with a VBA subroutine 0
Setting column width in a table with a macro is not working 0
Filtering out duplicate entries? 0
VBA Macro to unfilter specific column 1
Two columns followed by single page-width column on same page 0
Format column widths from one table to a separate table on same page 1

Top