R
Roadie
Select the rows you want to group and then in the Menubar, goto 'Data
and then 'Group and Outline'
and then 'Group and Outline'
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Diego Arbe
I have several rows which give me the totals of information in other sheets.
Let's put it graphically:
This is my main sheet:
_____________________________________
: Type 1 Type 2
: Category A 50 40
: Category B 20 10
: --------------------
: TOTAL 70 50
:
:____________/ Sheet 1 - Totals \____________
The information of the different categories come from sheets like this:
_____________________________________
: Date Type 1 Type 2
: xx/xx/xx 15 10
: xx/xx/xx 5 20
: xx/xx/xx 30 10
: -------------------
: TOTAL 50 40
:
:____________/ Sheet 2 - Category 1 \______
What I would like to do is to be able to have all the information in one
single page and not spread about in a lot of pages. It works like this but
its a mess as by now I need to use 23 pages for the different categories I
use.
Initially I testes putting all the information from the other pages in lists
but I just need the information to be THERE or to be hidden and just see the
totals.
I remember at some point I saw an excel worksheet with hidden rows that
could be simple expanded or reduced with a plus "+" or minus "-" sign on the
left side of the page (with the numbers). I suppose that could be a solution
but I down even know how the command is called or how it works.
If anyone could give me a hand here I would be really greatful. If someone
has any example please email it to me (e-mail address removed)
Thank you,
Diego Arbe
Miami FL
Let's put it graphically:
This is my main sheet:
_____________________________________
: Type 1 Type 2
: Category A 50 40
: Category B 20 10
: --------------------
: TOTAL 70 50
:
:____________/ Sheet 1 - Totals \____________
The information of the different categories come from sheets like this:
_____________________________________
: Date Type 1 Type 2
: xx/xx/xx 15 10
: xx/xx/xx 5 20
: xx/xx/xx 30 10
: -------------------
: TOTAL 50 40
:
:____________/ Sheet 2 - Category 1 \______
What I would like to do is to be able to have all the information in one
single page and not spread about in a lot of pages. It works like this but
its a mess as by now I need to use 23 pages for the different categories I
use.
Initially I testes putting all the information from the other pages in lists
but I just need the information to be THERE or to be hidden and just see the
totals.
I remember at some point I saw an excel worksheet with hidden rows that
could be simple expanded or reduced with a plus "+" or minus "-" sign on the
left side of the page (with the numbers). I suppose that could be a solution
but I down even know how the command is called or how it works.
If anyone could give me a hand here I would be really greatful. If someone
has any example please email it to me (e-mail address removed)
Thank you,
Diego Arbe
Miami FL
N
Nitin
hi
You will need to use Data/Gruop & Outline/group to use the grouping
feuture.
Take care that u structure info in staircase like structure so that it
becomes easy to total.
Or you can explore the data/Subtotals function also
Or you can create a master data file which will contain information
upto the lowest level in a single file And then you can use pivot table
for summarising it.
Regards
Nitin
You will need to use Data/Gruop & Outline/group to use the grouping
feuture.
Take care that u structure info in staircase like structure so that it
becomes easy to total.
Or you can explore the data/Subtotals function also
Or you can create a master data file which will contain information
upto the lowest level in a single file And then you can use pivot table
for summarising it.
Regards
Nitin