Hide text when printing

Hello.

I have a report that I've created in Excel that I'm having trouble
printing properly. The report has alternating group colours - e.g. the
first group could be rows 2 through 5, and all these will have a white
background; the second group could be rows 6 and 7, and these will have
a grey background; the 3rd group could be rows 8 through 15, and we're
back to a white background, etc. Within each group, I have "hidden" the
duplicated fields by making the font colour match the background colour.
That is, if rows 2, 3, and 4 are in the same group, but the values in
column "A" are the same for all 3 rows, then cell A2 will have black
text but cells A3 and A4 will have text matching the background colour.

This prints fine for the groups with the white background, but the
groups with the grey background have the text visible on the printout in
all cells, despite the fact that it displays exactly how I want it to on
the screen.

Does anybody know how to fix this, so that it prints exactly how it
displays on the screen?

Thanks,

John

Hi,

Instead of changing the font color to suppress display of duplicates try
changing the cell's number format:

Select all the cell you want hidden. Choose Format, Cells, Number tab,
Custom and in the Type box enter ;;; (three semi-colons) In Excel 2007 you
can go one step further - Excel will automatically format duplicates to hide
the data, but you didn't say you were using 2007.

If this helps, please click the Yes button,

cheers,
Shane Devenshire

"John" <jrtwynam.TakeThisOut@rogers.com> wrote in message
news:4935ccd1$0$5050$9a6e19ea@unlimited.newshosting.com...
> Hello.
>
> I have a report that I've created in Excel that I'm having trouble
> printing properly. The report has alternating group colours - e.g. the
> first group could be rows 2 through 5, and all these will have a white
> background; the second group could be rows 6 and 7, and these will have a
> grey background; the 3rd group could be rows 8 through 15, and we're back
> to a white background, etc. Within each group, I have "hidden" the
> duplicated fields by making the font colour match the background colour.
> That is, if rows 2, 3, and 4 are in the same group, but the values in
> column "A" are the same for all 3 rows, then cell A2 will have black text
> but cells A3 and A4 will have text matching the background colour.
>
> This prints fine for the groups with the white background, but the groups
> with the grey background have the text visible on the printout in all
> cells, despite the fact that it displays exactly how I want it to on the
> screen.
>
> Does anybody know how to fix this, so that it prints exactly how it
> displays on the screen?
>
> Thanks,
>
> John