LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merged cells disturb autofilter indicator DocBrown Excel Worksheet Functions 2 July 3rd 09 07:32 PM
AutoFilter column w/merged cells ajsiko Excel Discussion (Misc queries) 1 June 24th 08 08:05 PM
Autofit Merged cell Code is changing the format of my merged cells JB Excel Discussion (Misc queries) 0 August 20th 07 02:12 PM
Autofilter on a worksheet with merged cells Ashish G Excel Worksheet Functions 2 November 9th 06 06:50 AM
Autofilter on blanks pulls merged cells Yvette L Excel Discussion (Misc queries) 1 October 11th 06 01:09 AM


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"