Wednesday, 3 September, 2008

"Excel"ing to Create Subtotal Row Totals

Sales Report ChartYour manager sends you an e-mail with a spreadsheet attached. They ask you to create subtotals for the latest sales report, but want you to only send them the revised spreadsheet showing the subtotal rows.

I recently ran into this problem as well. One of my managers wanted me to use our sales tracking software to create the sales report for a particular product. Then he mentioned that he didn’t want all of the details of each product listed. He only wanted the total amounts shown as a bundled figure.

This made my life a little difficult since I thought that I would have to copy and paste all of the subtotal amounts into this spreadsheet, as the report shows all of the details. On a side note, if you need help creating subtotals, check my post on using subtotal functions in Microsoft Excel.

I poked around the internet a bit and came to realize that there is a faster way of doing this. I was able to put the entire report together within a matter of minutes.

Once you’ve created your subtotals, follow these steps on creating only subtotal rows:

  1. Highlight everything from the headings to the grand total.

    Microsoft Excel - Subtotal Row Totals Only - 1 of 6
  2. Click the little number 2 shown below to collapse all of the details in between all of the companies.

    Microsoft Excel - Subtotal Row Totals Only - 2 of 6
  3. Click Edit, Go To.

    Microsoft Excel - Subtotal Row Totals Only - 3 of 6
  4. Click Special.

    Microsoft Excel - Subtotal Row Totals Only - 4 of 6

  5. Click Visible cells only and click OK.


    Microsoft Excel - Subtotal Row Totals Only - 5 of 6
  6. Click Edit, Copy or CTRL+C to copy.
  7. Open a new workbook and then click Edit, Paste or CTRL+V.

    Microsoft Excel - Subtotal Row Totals Only - 6 of 6

Now only the subtotal rows will show up, instead of all of the details in between.

Subscribe to The Professional Assistant feeds or get posts e-mailed directly to you today.

Until next time,

Take care - of your clutter!


Post from: Administrative Assistant










4 comments:

Mike W said...

I just wanted to say that this was super useful to me, and saved me a ton of time. Thanks for the walkthrough!

The Professional Assistant said...

Hi Mike,

Glad I could help out. I sometimes go onto my blog to look up stuff that I've added, since I tend to forget things at times.

Thanks,

Richard

Admin Assistant Jobs said...

i like this blog because this is very useful for me thanks for sharing

clerical jobs said...

Hey thanks for sharing it with us. Many time it happen that we did not get what we want, but anyways it's a nice post.

Post a Comment