Microsoft Excel Tutorial: How to move the subtotals right one column?

Welcome to the MrExcel Podcast, where we bring you the best tips and tricks for mastering Excel. In this episode, we will be discussing how to shift subtotals right one column. This is a common issue that many Excel users face, and we are here to provide a simple solution.

During a recent seminar in Springfield, Missouri, a participant named Rebecca approached me with a question. She wanted to add subtotals to her data set, but instead of having them in the same column, she wanted to shift them one column to the right. This may seem like a daunting task, but with the right steps, it can be easily achieved.

To add subtotals by account, start by selecting one cell in the account column. Then, go to the Data tab and click on the A to Z button to sort the data. Next, under the Outline group, click on the Subtotal button. In the Subtotal dialog box, select "At each change in Account" and choose the Sum function. Then, add the subtotal to the Amount column and click OK. Just like that, you will have subtotals at each change in the account number.

Now, to shift the subtotals one column to the right, we need to collapse the data to the #2 view. This can be done by clicking on the Group and Outline buttons that were added by the Subtotal command. Then, select all the visible cells by choosing one column to the left of the subtotal column and using the shortcut key Alt+;. Next, go to the Home tab and click on Insert, then select "Shift cells right" and click OK. This will move the subtotals to the desired column. Finally, go back to the #3 view and you will see the totals in the new column.

In this episode, we have covered a simple yet effective solution for shifting subtotals right one column. But that's not all, in my book "617 Excel Mysteries Solved", you will find even more tips and tricks for mastering Excel. Click on the "I" in the top right-hand corner for more information about the book. And as always, thank you for tuning in to the MrExcel Podcast. We'll see you next time for more Excel tips and tricks.

Buy Bill Jelen's latest Excel book: [ Ссылка ]

You can help my channel by clicking Like or commenting below: [ Ссылка ]

#excel
#microsoft
#microsoftexcel
#exceltricks
#excelhacks
#evergreen
#excelsubtotal

This video answers these common search terms:
how to move excel subtotals one column to right
shift excel subtotals one column to the right
shift excel subtotals into blank column
move just subtotal rows in excel

Table of Contents:
(00:00) Shift Subtotals Right One Column
(00:25) Adding Subtotals by Account
(00:48) Using Group and Outline buttons
(01:12) Using shortcut key to select visible cells
(01:45) Inserting cells to shift Subtotals right
(01:56) Clicking Like really helps the algorithm


Sort the data by account
Data, Subtotals, At Each Change in Account, Sum the Amount
Use the #2 group and outline button to show only the totals
Select all of the blanks in one column to the left of the subtotals
Use Home, Find & Select, Go To Special, Visible Cells Only or Alt+;
Home, Insert, Cells, Shift Cells Right
Click the #3 Group & Outline button

Join the MrExcel Message Board discussion about this video at [ Ссылка ]

свернуть