ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   filter only one column (https://www.excelbanter.com/new-users-excel/157468-filter-only-one-column.html)

LMD

filter only one column
 
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??

Dave Peterson

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

Then apply data|filter|autofilter.

LMD wrote:

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??


--

Dave Peterson


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com