Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to group rows and columns in Excel 2010
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

How to group rows and columns in Excel 2010

Let's learn how to  group rows and cells in Excel to make complex spreadsheets much easier to deal with.

 
  Author: mat | Version: 2010 | 20th October 2012 |  
 
 
1.
 

Open an Excel spreadsheet. Let's say I want to group and hide the column C and D so I will only see the Name and the Cost column together.

 
 
2.
 

Select the columns C and D.

Click on column C, hold your mouse and drag it over the column D to select two or more columns.

 
 
3.
 

Click the Data tab in the menu.

 
 
4.
 

And click the Group button.

 
 
5.
 

Both columns are now grouped. Notice the line and the minus (-) sign above the columns you grouped.

Simply click the minus ...

 
 
6.
 

... and the grouped cells are now hidden. To bring them back simply click the + button.

 
 
 
   
  Please login to post a comment
  Click to open user profile  
NikMan, 20th Oct 2012, 7:27 AM
Thank you for this tutorial. It will help me at my job.
 
 
  Click to open user profile  
mat, 20th Oct 2012, 7:37 AM
No problem, I'm glad it helped.
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO