Grouped columns & rows

G

Guest

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?
 
R

RagDyer

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Grouped Rows when sheet is Protected 2
Grouping on protected worksheets 4
Collapsing/expanding grouped areas on multiple pages 1
Expand/Collapse in Pivot Tables 2
How can I group and display columns automatically? 3
group/ungroup column/row buttons 5
Multiple column filtering 2
VBA: Collapse Column Groupings 1

Top