#1
|
||||
|
||||
How to Remove the subtotal columns in a sheet
Hi. I would like help on how to remove the 1 2 3 subtotal columns on the left side of a sheet. I deleted the subtotals but the 1 2 3 columns still remain. These occupies precious space when files are opened in cellphones.
Thank you. |
#2
|
||||
|
||||
Select the rows which have the outlining, then in the Data tab of the ribbon, in the Outline section, click on Ungroup dropdown, then Clear Outline.
|
#3
|
||||
|
||||
Done, but the 1 2 3 are still there.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Relating cells in a row in one sheet to cells in columns on another sheet. | mbesspiata3 | Excel | 2 | 01-06-2017 05:42 AM |
Create a New Sheet from Existing Sheet with Specific Columns | malam | Excel Programming | 1 | 10-17-2014 10:01 PM |
From an XL sheet ,how to keep the group of columns which match with other XL sheet | Zubairkhan | Excel | 2 | 03-04-2014 10:57 PM |
Removing columns within sheet | shabbaranks | Excel | 2 | 09-11-2012 05:03 AM |
Each subtotal signature require only at last page for each subtotal. | aligahk06 | Excel | 0 | 05-07-2010 11:07 PM |