![]() Now click the “Data” tab from the top menu.Open the spreadsheet in which you want to add subtotals.When you’re done rearranging the data in your spreadsheet, you might want to add a new set of subtotals. Hopefully, you’ve managed to remove the subtotals using the guidelines from the previous two sections. You can do that without deleting the entire pivot table. If you’re working with pivot tables in Excel, there’s no need to create a new table only to remove the subtotals. Now click the “Clear Outline” option to remove any grouping for that spreadsheet.In the “Outline” section, click the “Ungroup” drop-down menu.If you don’t want to delete the subtotals, but want to remove all groups to further rearrange your data, do the following: This will ungroup all the data in the spreadsheet, effectively removing any subtotal rows you might have there.In the “Subtotal” menu, click the “Remove All” button.In the “Outline” section of the top menu, click “Subtotal”.Open the Excel spreadsheet you want to edit.Whether you simply want to remove subtotal rows from your spreadsheet or reorganize the entire sheet, the process is basically the same. Removing Subtotals from Standard Spreadsheets
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |