Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003, sp2
Hi, I have a table with quarters in column A. Each quarter has its related months in column B. The cells in column A that represent each quarter are merged - I don't want the quarters repeated for each month.. When I apply the autofilter and filter col A only the first month in col B is displayed. However I want all 3 related month to be displayed. One work-around that works is to unmerge the cells in col A and enter quarter values for each month in column B and change the text color for the duplicate quarter values to white. The "hidden" values are however visible to the user if he selects the cells. Is there a way to solve this which lets me keep the merged quarters in col A? Regards Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merged cells disturb autofilter indicator | Excel Worksheet Functions | |||
AutoFilter column w/merged cells | Excel Discussion (Misc queries) | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Autofilter on a worksheet with merged cells | Excel Worksheet Functions | |||
Autofilter on blanks pulls merged cells | Excel Discussion (Misc queries) |