How to Remove the subtotal columns in a sheet

Marcia · #1 11-29-2023, 10:58 PM

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.

p45cal · #2 11-30-2023, 06:28 PM

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.

Marcia · #3 12-01-2023, 12:39 AM

Quote:

Originally Posted by p45cal

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.

Done, but the 1 2 3 are still there.

p45cal · #4 12-01-2023, 05:48 AM

See if you can play the video linked here:
Box
This does not happen with you?

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