View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Excel - unHiding a column affects columns in other worksheets?

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...