Hiding Columns

[Bobi_Pixley]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

In my PC version of Excel I can select columns and hide them. Then, unhide them later. My spreadsheet has so many columns I need to be able to hide some of the columns to make viewing easier while preserving the old data.

How do I do this with my Mac?

Thank you!

Bobi

 

[CyberTaz]

Although Excel 2007 is a little different because of the Ribbon Mac Excel
works the same in that regard as any other PC version: Select one or more
columns then use Format> Columns> Hide or Control/Right-Click the selected
column(s) & choose Hide from the shortcut menu.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Lost]

I got a spreadsheet from a friend and on the top it showed you the hidden columns. I could press the plus sign to show the hidden columns and hit the minus sing to hide the columns again. I can't figure out how to do this. Help!

 

[CyberTaz]

What you're referring to is not the same as Hiding columns & rows. That
sheet has had the Group & Outline feature applied to it. See the following;

http://office.microsoft.com/en-us/excel/HA100244981033.aspx

HTH |:>)
Bob Jones
[MVP] Office:Mac