How to Ungroup Tabs in Excel. Business managers and owners group worksheets in Excel so that changes made to one worksheet apply automatically to all connected worksheets.

Click the Lists sheet tab or the tab that contains your list items. Select the list (A1:A4). Click OK, which will return you to the new sheet, where you’ll find a populated list in E4 ( Figure A ).