| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is this symbol? | Excel Worksheet Functions | |||
| X Bar Symbol | Excel Discussion (Misc queries) | |||
| what shortcut key do I use for the + symbol over the - symbol | Excel Discussion (Misc queries) | |||
| $ Symbol | Excel Discussion (Misc queries) | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Hybrid Mode
