Grouped columns & rows

W

WBKLAK

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

Grouping on protected worksheets 4
Expanding Grouped Rows when sheet is Protected 2
Expand/Collapse in Pivot Tables 2
Need Help with a VBA subroutine 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Copy addition formula of non-consecutive horizontal cells 2
Report Group Footer DLookUp 0
Collapsing/expanding grouped areas on multiple pages 1

Top