| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter Single Column | Excel Discussion (Misc queries) | |||
| Excel 2007 Filter in Column | Excel Worksheet Functions | |||
| Filter data from one collum by looking up from another column | New Users to Excel | |||
| How to filter 7 columns in a 20 column spreadsheet? | Excel Worksheet Functions | |||
| How do I use auto filter on only 1 column in a spreadsheet? | Excel Worksheet Functions | |||
Linear Mode
