Plus symbol at top of page

B

Beep Beep

I have inherited a Excel Spreadsheet that has what looks like sumtotals
format at the top of the page. They are not subtotals. What they do is
expand some hiden columns whereby some columns have numbers and some do not,
however they all total to the one at the top. This is what it looks like
across the top.
+ + + + + + + + etc.

When you click on one of the plus symbols it opens multiple columns that are
hidden from the one.?????

Help
Confused.
 
D

Dave Peterson

And you're looking to know how they were created????

Select some columns and do
data|Group and outline

and you'll see.
 
B

Beep Beep

Thanks Dave. Piece of cake.

Frank

Dave Peterson said:
And you're looking to know how they were created????

Select some columns and do
data|Group and outline

and you'll see.
Click to expand...
 

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

Issue with hidden field in Pivot table 1
Freeze column headers for ledger sheets 1
ASK Field Formatting 1
Insert Index into a Table 1
Top 25 offenders after summing 1
I am trying to Make a column on Top 4 Cells, and Under 5 Cells. 1
Running Total at top of Page? 0
how to return "summary" of all non-blank cells plus their headers 10

Top