FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -To remove an applied auto outline, click the “Data” tab in the Ribbon. Then click the drop-down “Ungroup” button in the “Outline” button group. Then select the “Clear Outline” command from the button’s drop-down menu. This will remove any outlining from your worksheet.

Detailed explanation-2: -Ungroup rows or columns To ungroup, select the rows or columns, and then on the Data tab, in the Outline group, click Ungroup and select Ungroup Rows or Ungroup Columns.

Detailed explanation-3: -To remove grouping for certain rows without deleting the whole outline, do the following: Select the rows you want to ungroup. Go to the Data tab > Outline group, and click the Ungroup button. Or press Shift + Alt + Left Arrow which is the Ungroup shortcut in Excel.

Detailed explanation-4: -The ungrouping of data works as follows: To ungroup the entire data, clear the outline. Click “clear outline” under the “ungroup” arrow (“outline” section of the Data tab). To ungroup particular data, select the rows to be ungrouped.