How do you group data in excel?



How do you group data in excel?..

Answer / Satyajeet Kumar

"To group data, select the column to be grouped, then go to Data > Group & Outline. Choose the number of groups from the dialog box and click OK. To expand or collapse a group, click on the arrow next to the group header."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is data spreadsheet?

1 Answers  


What is the use of conditional formatting in excel?

1 Answers  


How do you write a summary report?

1 Answers  


I have a price list stored in a worksheet, and I need to increase all prices by 5 percent. Can I do this without reentering all the prices?

1 Answers  


How use vlookup step by step?

1 Answers  


What is the formula in excel to subtract multiple cells?

1 Answers  


How do I ungroup sparklines in excel?

1 Answers  


What do employers test for in excel?

1 Answers  


What is form control in excel?

1 Answers  


How do you total a column in excel?

1 Answers  


What is flash fill in excel?

1 Answers  


How do you auto calculate in excel?

1 Answers  


Categories