How do I group and ungroup in excel 2016?



How do I group and ungroup in excel 2016?..

Answer / Deepankar Singh

To group rows in Excel 2016, select the row(s) you want to group, then right-click and select 'Format as Table'. To ungroup, click on the table design tab, click on 'More tables', and choose 'Clear formatting'.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do I use scenario manager in excel 2010?

1 Answers  


How do you sum only certain cells in excel?

1 Answers  


How do I manage customer database in excel?

1 Answers  


How to email a portion of an excel spreadsheet?

1 Answers  


How do I create a chart in excel 2016?

1 Answers  


How can the users return to any particular area of a worksheet?

1 Answers  


What is an array formula in excel?

1 Answers  


Why is a sensitivity analysis important?

1 Answers  


How do you change conditional formatting in excel?

1 Answers  


How do you analyze data in excel?

1 Answers  


How do I truncate text in excel?

1 Answers  


What are the 3 types of cell references in excel?

1 Answers  


Categories