Plus symbol at top of page
 

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.

Plus symbol at top of page
 

Check out Data-Group and Outline.

Regards,
Paul

"Beep Beep" wrote in message
...
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.

Plus symbol at top of page
 

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

Select some columns and do
data|Group and outline

and you'll see.

Beep Beep wrote:

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.

--

Dave Peterson

Plus symbol at top of page
 

Thanks Dave. Piece of cake.

Frank

"Dave Peterson" wrote:

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

Select some columns and do
data|Group and outline

and you'll see.

Beep Beep wrote:

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.

--

Dave Peterson