shortcut for subtotal?

  • Thread starter Thread starter sokevin
  • Start date Start date
S

sokevin

does anyone know the shortcut for subtotal?

e.g if i selecet a1:a10, is there a shortcut to do the following

=subtotal(9,a1:a10)


thanks :
 
Do a Customize on your toolbar and add the subtotals button from the Data
Commands group.

Nikos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal Average excluding zero 9
ABS in SUBTOTAL 3
Count of Font Format 1
Collapse subtotals? 6
Subtotal - Additional Formulas based on Subtotal range(s) 6
Average of Subtotals in Pivot Table 0
Subtotals 5
Need to combine two working formulas - not working. 2

Back
Top