TOLL FREE: 1 855 TRUE SKY (878 3759)

Blog

Read up for news, tips and tricks about budgeting, planning and forecasting.

Excel Tips

Horizontal Totals in Excel

We’re getting back to basics with Excel- the tool we all love and hate. If you hate Excel sheet formulas, not to worry with this tip, since this one doesn’t use any.

1) Copy the data in the row that you want to total.

excel vertical to horizontal

2) Paste the data below using the Transpose Paste.

Excel vertical to horizontal

3) Under the Data tab, click on Subtotal.

excel vertical to horizontal

4) Click OK.

Excel Horizontal

5) Copy the newly formed chart and Transpose Paste it into A1.

excel vertical to horizontal

6) (Optional) You can Group these numbers by using the group function under the Data Tab. Group all the columns that are desired.

excel vertical to horizontal

7) Delete the vertical chart, and now you are done.

excel vertical to horizontal

 

Check our events page for future True Sky webinars.