ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Grouped columns & rows (https://www.excelbanter.com/excel-worksheet-functions/111849-grouped-columns-rows.html)

WBKLAK

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?


RagDyeR

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?



Dave Peterson

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


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com