Data Grouping in Excel Sheet.

Asked By sumon_ 0 points N/A Posted on - 10/31/2012

Hi,

I have 25 columns in a Excel Sheet. How can I create Data Group in that Excel Sheet?

• Status: Open
• Question Views: 878
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by George Stacy

Go To Solution

Best Answer

Best Answer

Answered By George Stacy 0 points N/A #161386

Data Grouping in Excel Sheet.

Hi user _Sumon,

I made you a solution that may solve your problem. First you should do is to input those data or group in the excel. After doing so highlight those cells you want to group. Press Data on Menu Bar > Groups. Upon clicking it, will be prompt of rows or columns. On our case we want it by rows. Then you will see a Minimize button. If you click that all those names will be hidden.

Just Click Maximize button to see those names again.

Hope this helps you with your problem,

About George Stacy

Questions
3

Answers
100

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 10/31/2012
• Question Category: MS Excel

Answered By Jackson Paul 0 points N/A #161387

Data Grouping in Excel Sheet.

Hi,

There are many ways to insert a data group inside a worksheet. You mentioned you have 25 columns in your excel sheet. Try this official link to get solution. Here you’ll have to complete the data group before inserting it as a data group.

Thanks.

About Jackson Paul

Questions
3

Answers
60

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 10/31/2012
• Question Category: MS Excel