How To Group Worksheets In Excel?

Click the first worksheet tab you want to group

Hold down Ctrl and click additional worksheet tabs to group specific sheets

To group adjacent sheets, click the first tab, hold Shift, and click the last tab

Right-click any selected sheet tab and choose Select All Sheets to group every worksheet

To ungroup sheets, right-click a grouped tab and choose Ungroup Sheets

To ungroup all sheets, click any sheet tab that is not grouped

Check the title bar for the word Group to confirm worksheets are grouped

Suggested for You

Trending Today