Hi Glen

You're very welcome. Thanks for the feedback.
Sometimes I can wander around in forests all day<bg.

--
Regards

Roger Govier


"Glen" wrote in message
...
Roger,

My apologies for poor description. If you place your cursor in the
formula bar, then press F9, Excel will calculate the formula, (or
whatever part of the formula you have highlighted) and show the
result.

Hey, that's cool. I never knew that. Well, that's my new trick for
the day.

I think you have come up with your own solution.
Just use the Drawing toolbar to place a rectangle over the cells in
question. Enter your heading names in the boxes created and right
click
the shape, Format AutoshapeProperties untick the Print box

Hmmm. Sometimes it just takes someone else to see the wood for the
trees.
That is a kind of obvious work around, although I still think it
should be
possible to select particular cells as non-printing.

Thanks for your help,

Glen