Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I filter columns of merged cells to show all related rows?
Need to allow filtering of a column with merged cells to show the rows
associated with each merged cell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I filter columns of merged cells to show all related rows?
Instead of merging the cells, you could enter the value in each cell,
then use conditional formatting to hide the duplicates. There are instructions he http://www.contextures.com/xlCondFor...html#Duplicate mosaic wrote: Need to allow filtering of a column with merged cells to show the rows associated with each merged cell -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I filter columns of merged cells to show all related ro
Many thanks, this works fine.
"Debra Dalgleish" wrote: Instead of merging the cells, you could enter the value in each cell, then use conditional formatting to hide the duplicates. There are instructions he http://www.contextures.com/xlCondFor...html#Duplicate mosaic wrote: Need to allow filtering of a column with merged cells to show the rows associated with each merged cell -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows with empty cells in columns B&C | Excel Discussion (Misc queries) | |||
copy formulas to cells absolute rows and variable columns | Excel Discussion (Misc queries) | |||
Sorting Area with Merged Cells | New Users to Excel | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
Getting Excel to treat merged cells as one cell when printing | Excel Discussion (Misc queries) |