Hi,

I recommend making all the titles merges of the same number of cell - when a
title uses only 2 cells for merging, increase it to 3 cell. Or putting the
titles into one cell (row) and wrapping the text.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Gavelle" wrote:

I used the advanced filter, but i'm still missing the border between the
hidden rows for the title. The border still appears as it did before for all
the other cells that aren't merged in each row.

Do you have any other ideas? I'd love to figure something out to make this
work :-)

--
Gavelle
Having fun with Access!


"Luke M" wrote:

When you setup the autofilter, don't include the column that has your titles.
That way Excel won't think you're wanting to hide them when you apply your
filter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gavelle" wrote:

I have an excel worksheet were some cells are merged with cells in other
rows, and other cells are not merged. Specifically, the cells with titles
are merged over multiple rows, while the cells with data are not merged.
Title X covers three rows: 2,3,&4. Title Y covers two rows, 5&6. When i
apply a filter and only rows 3 & 6 are visible, the borders are not showing
up between title X & title Y.

Is there a way to force the border between title X & Y to stay even when
rows are hidden? Thank you in advance, I hope that my explanation isn't too
confusing!

--
Gavelle