Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2005, 03:53 AM
volcane volcane is offline
Novice
How to do grouping in Excel
 
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
obenix obenix is offline
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
volcane volcane is offline
Novice
How to do grouping in Excel
 
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
How to do grouping in Excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft