Excellence in Excel Series- Part 1 using subtotals

CA ANKUSH AGGARWAL , Last updated: 26 December 2014  
  Share


STEP-1: Sort the list on the field/s for which you want subtotals inserted using multi level sorting Select the whole data including headers using ctrl+A ,click on Data and select Sort. Use Add level option to enable multi level sorting fields. STEP-2: Click the Subtotal

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 1999/-

Offer Price : INR 999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)
Join CCI Pro

Published by

CA ANKUSH AGGARWAL
(CHARTERED ACCOUNTANT)
Category Students   Report

15 Likes   26822 Views

Comments


Related Articles


Loading