Hiding columns or rows in Excel

[Alant]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

there are some shortcomings in the Office for Mac suite that Office XP has.

one is hiding columns or rows. when I highlight a column and click hide, it hides the entire sheet not just the column within the sheet.

Is this function available in Office for Mac?

 

[CyberTaz]

Hi Alan -

Please see in line below:

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

there are some shortcomings in the Office for Mac suite that Office XP
has.

That point is arguable both ways

one is hiding columns or rows. when I highlight a column and click hide,
it hides the entire sheet not just the column within the sheet.

But this isn't one of "differences"...

Is this function available in Office for Mac?

Just like in 2002/2003 the primary command is Format> Column> Hide. There's
no need to highlight a column to Hide it. Simply Control/Right-Click the
Column Heading & select the Hide command in the shortcut menu. If you're
experiencing something different there must be an explanation.

Be sure you have OS X & Office fully updated & have repaired permissions
after any update. Once you're certain all is up to date reply with a
complete description of exactly what steps you're taking as well a some
insight on the file involved. Is it just this one sheet or all sheet plus
any additional details.

 

[Alant]

Thanks. I still haven't broken all my PC habits. Didn't know the column hide function was in Format. on a PC it is in Window.

 

[Mike Middleton]

Alan -

In Windows Excel versions 97 through 2007 (and probably earlier versions
which I no longer have on this computer), the menu command for hiding a
column is Format | Column | Hide.

In those versions, the Hide item on the Window menu is only for hiding the
complete window.

- Mike Middleton
http://www.MikeMiddleton.com