Home » Tips N Tricks » Office Tips » Got huge data in Excel ? Group columns or rows

Got huge data in Excel ? Group columns or rows

Quick Tip: Microsoft Excel has got this superb feature of grouping and ungrouping when your excel files has huge amount of data ( Excel files are always in corporate world ). All you need is to select cells which you want to group and then  Group > Rows or Cells from the Data Tab in Excel 2007.

Group Columns and Rows in Excel

Group Columns and Rows in Excel

This makes viewing of large excel files easier and this option is lot better than hiding cells or columns.


About Ashish Mohta

A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. His expertise are in Windows 7, Microsoft Office, Software, Mobile Apps and Video Posts.