Open an Excel file, and decide carefully the worksheets on which you want to apply the common changes. Press Ctrl, and then use the mouse to select the sheets you want to group.

Excel Group feature allows users to group rows or columns. Ungroup is used to ungroup a range of cells or data that were previously grouped.

How to Close All Excel Files at Once. When you're working on multiple spreadsheets at a time in Microsoft Excel, closing them all one by one is wasted time you could have spent on another task.