| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting data out of a single cell | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Conditional formatting a full row triggered by a single cell reference... | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
