Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

subtotals

ResolvedVersion Standard

Michelle has attended:
Excel Intermediate course

Subtotals

What is the maximum number of subtotals I can have?

RE: Subtotals

Hello Michelle,
I hope you enjoyed your Excel training session with us.

In response to your question, you can apply subtotals multiple times, if you want to apply them to multiple columns or if you want to apply other functions (AVERAGE, COUNT, etc). I am not aware of the maximum number of times you can apply subtotaling - you may want to test it out!

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.