Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Grouped columns & rows

I have grouped columns and rows, but I cannot see the +/- buttons in the
margins of the excel program to expand or collapse my groupings. How do I
get the +/- buttons to show?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default Grouped columns & rows

You can toggle the "view outline symbols" on and off by:

<Ctrl <8

Using the "8" from the keys under the function keys, *not* the key from the
num keypad.

OR
<Tools <Options <View tab,
And under "Window Options",
*CHECK*
"Outline Symbols".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"WBKLAK" wrote in message
...
I have grouped columns and rows, but I cannot see the +/- buttons in the
margins of the excel program to expand or collapse my groupings. How do I
get the +/- buttons to show?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Grouped columns & rows

Maybe...

Tools|Options|View Tab|check Outline Symbols

WBKLAK wrote:

I have grouped columns and rows, but I cannot see the +/- buttons in the
margins of the excel program to expand or collapse my groupings. How do I
get the +/- buttons to show?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 06:54 PM
How can I transpose rows to columns in a large worksheet? ratchick Excel Discussion (Misc queries) 7 November 11th 05 05:25 PM
Is there a limit in the number of columns that can be grouped? Mike Excel Discussion (Misc queries) 1 September 16th 05 06:07 PM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM


All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"