USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Group
|
|
|
Outline
|
|
|
Remove group
|
|
|
Ungroup
|
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: -You can clear (delete) an outline by clicking on the Data tab then clicking on the bottom half of Ungroup and selecting Clear Outline. To remove it from the entire worksheet, click on any one cell first. To clear only a part of an outline, select only the cells you want to clear.
Detailed explanation-3: -The Excel Group Ungroup Tool allows you to hide and unhide selections of rows or columns in a safer way then the traditional hide and unhide. Related Links: Filter Data into groups, Group Data via Pivot Tables. Under the DATA tab as part of the Outline box you have the Group and Ungroup function.
Detailed explanation-4: -Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.