Many thanks, I had just discovered the group feature and that it was causing
my problem, also with the printing issue. It would help if one could easily
see that the tabs were selected. I cant see the difference - selected or
unselected.

Thanks again

"JLatham" wrote:

Can you describe your actions in each case? I just opened up Excel 2007 and
went to each of the 3 sheets individually, hiding column D on each sheet.
Went back to Sheet1 and selected columns C:E and unhid D without it changing
anything on the other 2 sheets.

Haven't tried anything with priting or creating pdf just yet.

Do you have all sheets selected as a group when you try either of these
operations? That would definitely explain the unhide column problem.

"John Powell" wrote:

I have just upgraded to office 2007. Looks great but..if I hide or unhide a
column in one sheet it affects columns in another sheet also?

And I cant print or pdf just one sheet. I get all the pages even when only
one is selected...