I just saw a sample spreadsheet that had a grey colum to the left of the row numbers. In this area is a "+" symbol that when clicked unhides the rows that are hidden starting with the row directly to the right of this "+" sign. After it unhides these rows, there is a "-" sign to the left of the last unhidden row. If you click the "-" sign, the rows will, once again, be hidden. Anyone know how this is done?
Last edited by rkjudy; 12-11-2009 at 01:53 PM.
It is called grouping but i am not sure how to in 2003.
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
That is called Grouping... found in Data|Group and Outline
Data| Subtotals will also add these if your are subtotalling in groups.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks