Hello. I am trying to achieve something that may only be available via 3rd party addons but I have seen this before and have always wanted to incorporate.
Example
Rows 1 - 10 have data and then Id click a collapse/expand icon on the left and roll them up into a single line, row 1. The next row would be 11. It doesnt have to sum them, although that would be an added bonus, but simply to view or hide unwanted data.
Any ideas? Thanks
Good afternoon RoachForLife
...and welcome to the forum!
If you want to have a summary line, you're going to have to prepare it manually, but to collapse several rows, select the rows and go to Data > Group and Outline > Group.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
wow didnt realize it was so darn easy. I looked high and low (or so I thought) and couldnt find this. Thanks
Besides the tips/tutorials board on here any good sites for some useful tutorials on excel that maybe most people dont ever think about or never realized excel could do. Thanks
Hi RoachForLife
You're welcome. Appreciate the feedback.
If you're looking for ways to improve your Excel skills then have a look at these links here that some of us on the board put together. There will be dozens of tutorials and hundreds of VBA routines / examples and it will probably keep you quiet for a while...!
http://www.excelforum.com/showthread.php?t=584092
HTH
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks