View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PO PO is offline
external usenet poster
 
Posts: 66
Default Autofilter used with merged cells

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