hide/unhide columns & rows

[K_Sarno]

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

I've noticed on spreadsheets I've gotten from others a gray border on the top (immediately above column letters) and left side (immediately next to row numbers) of a worksheet that has "+" or "-" designations that when clicked on hide or unhide columns or rows. It seems like a short cut.
How do you set that up on a new spreadsheet or add it to a pre-existing spreadsheet?
I'm sure it's simple, but I can't figure it out.
Thanks,
KS

 

[CyberTaz]

You're seeing evidence of the Group & Outline feature available in the Data
menu. Unfortunately Help is totally devoid of any information on the
feature. Have a look here:

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

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

 

[K_Sarno]

Thank you!
FYI- for others, the Group & Outline function in Excel 2008 is found under the Data menu (not the Tools menu where it was in Excel 2003)

KS

 

[CyberTaz]

You're most welcome, but the Group & Outline feature has *always* been in
the Data Menu... Just did an Excel 2003 class last week that included it

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

 

[K_Sarno]

Ah - interesting, because the link you sent me directs you to the Tools menu to view the Outline Symbols...
Anyway, your reply certainly gave me the answer!
Have a great day
Karen

You're most welcome, but the Group & Outline feature has *always* been in

 

[CyberTaz]

Huh??? I just tried the link & it directs me here:

Home > Products > Excel > Excel 2003 Help and How-to > Working with
Data > Analyzing Data > Summarizing Data in Lists and Tables >
Outlining

The title of the page is "Outline a list of data in a worksheet". I have no
idea how you got to any such
information because the Tools menu in Excel doesn't have a listing for
Outline Symbols or anything that
even comes close. I think you somehow got oriented to the lower part of that
page where there is a
topic ("Show or Hide Outlined Data") which refers to *hiding/unhiding* the
symbols if the feature has been
applied but the symbols don't show or vice-versa. Is this what you mean:

"If you don't see the outline symbols ,[graphics not supported here] , and ,
click Options on the Tools menu, click the View tab, and then select the
Outline symbols check box."

IOW, the View options determine whether the Outlining is visible or not...
and Macs don't have Options
in teh Tools menu anyway

Try clicking the word Outlining in the above link, then click the first link
on that page - but make sure you start at the *top* of the page. Then try
the other links for more information.
--
Regards |:>)
Bob Jones
[MVP] Office:Mac