Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2023, 10:58 PM
Marcia's Avatar
Marcia Marcia is offline How to Remove the subtotal columns in a sheet Windows 11 How to Remove the subtotal columns in a sheet Office 2021
Expert
How to Remove the subtotal columns in a sheet
 
Join Date: May 2018
Location: Philippines
Posts: 523
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Attached Images
File Type: jpg SubTotal Cols.jpg (237.6 KB, 13 views)
Reply With Quote
  #2  
Old 11-30-2023, 06:28 PM
p45cal's Avatar
p45cal p45cal is offline How to Remove the subtotal columns in a sheet Windows 10 How to Remove the subtotal columns in a sheet Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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.
Reply With Quote
  #3  
Old 12-01-2023, 12:39 AM
Marcia's Avatar
Marcia Marcia is offline How to Remove the subtotal columns in a sheet Windows 11 How to Remove the subtotal columns in a sheet Office 2021
Expert
How to Remove the subtotal columns in a sheet
 
Join Date: May 2018
Location: Philippines
Posts: 523
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by p45cal View Post
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.
Reply With Quote
  #4  
Old 12-01-2023, 05:48 AM
p45cal's Avatar
p45cal p45cal is offline How to Remove the subtotal columns in a sheet Windows 10 How to Remove the subtotal columns in a sheet Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Remove the subtotal columns in a sheet Relating cells in a row in one sheet to cells in columns on another sheet. mbesspiata3 Excel 2 01-06-2017 05:42 AM
How to Remove the subtotal columns in a sheet Create a New Sheet from Existing Sheet with Specific Columns malam Excel Programming 1 10-17-2014 10:01 PM
How to Remove the subtotal columns in a sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft