How to roll up columns or rows for summary purposes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to have several levels of detail in my worksheets by
means of rolling up columns or rows and just displaying the column or rows
with the totals. By simply clicking on a + or - signs the roll up could be
performed or undone..I have seen this working, actually I am looking at
somebodý else's sheet but no clue how to aplly it myself.
 
Data>Group and Outline

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to be able to have several levels of detail in my worksheets by
| means of rolling up columns or rows and just displaying the column or rows
| with the totals. By simply clicking on a + or - signs the roll up could be
| performed or undone..I have seen this working, actually I am looking at
| somebodý else's sheet but no clue how to aplly it myself.
 
You must log in or register to reply here.

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

Rolling Average 2
Summary using sumif 9
hidden rows problem 7
data to summary sheet for a dummy 0
Writing formula to worksheet... 2
how do the details in an excel spreadsheet move to a summary page 6
Copy summary data to new sheet 1
dynamic summary report 11

Back
Top