Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-29-2005, 03:53 AM
Novice
 
Join Date: Apr 2005
Posts: 12
volcane is on a distinguished road
Default How to do grouping in Excel


is it possible to create grouping in Excel? Example I have 3 item under a title Salary: Wages, Bonuses, Travel Claim. Whai I want to achieve was allow user user click to show or hide the sub item. Just like the Folder Tree you have where you click on the folert icon to hide the sub folder.
Reply With Quote
  #2  
Old 04-29-2005, 11:33 PM
Novice
 
Join Date: Apr 2005
Posts: 14
obenix is on a distinguished road
Default

Under your excel menu, go to Data->Subtotal. Use this function to perform grouping. However, the first dtep to using this function is to highlight the columns that you want to group...
If you have further questions, post here and I will do my best to help you...
Reply With Quote
  #3  
Old 04-30-2005, 09:23 PM
Novice
 
Join Date: Apr 2005
Posts: 12
volcane is on a distinguished road
Default

Thanks obenix, this is what I want. Saw this on someone screen just dunno how to do it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM


All times are GMT -7. The time now is 07:13 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft