Subtotal function is greyed-out - can't insert

  • Thread starter Thread starter jmcclain
  • Start date Start date
J

jmcclain

I am trying to insert subtotals into a spreadsheet. I have made sure there
are no blank dells or columns, but the "subtotal" option is still greyed out.

Can anyone assist?

Using Excel 2003.

Thanks

Jon
 
Is the sheet protected? Unprotect it.

Do you have more than one sheet selected? Ungroup the sheets.

Is the workbook "shared"? Unshare it.



Gord Dibben MS Excel MVP
 
By chance, is your workbook a 'shared workbook'?
Tools > Shared Workbook > Uncheck the little box > OK

HTH,
Ryan---
 
Hi,

The range which you are trying to run the subtotal functionality on may be a
Table (List in Excel 2003). Remove the list and then you will be able to
subtotal. To remove a list, go to Data > List Conver to Range

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Subtotalling 1
Import external data into Excel 2007 so I can subtotal it 2
Subtotal function not available 3
Subtotals in Excel 2007 TABLES 1
Sub Totals option greyed out 1
Subtotal out of sequence 1
subtotal function won't work 1
automatic subtotal 1

Back
Top