Subtotal function is greyed-out - can't insert

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
 
G

Gord Dibben

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
 
R

ryguy7272

By chance, is your workbook a 'shared workbook'?
Tools > Shared Workbook > Uncheck the little box > OK

HTH,
Ryan---
 
A

Ashish Mathur

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

I am trying to assign resources to tasks but the 'Assign Resources' is greyed out on the Resource tab. 0
Problem with subtotal function 0
Real-Time Co-Authoring stops working 0
Can't subtotal data from query 0
Insert Menu Greyed Out 0
Save is Greyed Out 1
Import external data into Excel 2007 so I can subtotal it 2
Can I use the subtotal function while a worksheet is protected? 0

Top