Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Subtotal function is greyed-out - can't insert
1,865 views
Skip to first unread message
jmcclain
Dec 9, 2009, 11:19:01 AM12/9/09
to
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.
are no blank dells or columns, but the "subtotal" option is still greyed out.
Can anyone assist?
Using Excel 2003.
Thanks
Jon
Gord Dibben
Dec 9, 2009, 2:41:22 PM12/9/09
to
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
ryguy7272
Dec 9, 2009, 5:31:43 PM12/9/09
to
By chance, is your workbook a 'shared workbook'?
Tools > Shared Workbook > Uncheck the little box > OK
Tools > Shared Workbook > Uncheck the little box > OK
HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
Ashish Mathur
Dec 9, 2009, 8:18:11 PM12/9/09
to
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
"jmcclain" <jmcc...@discussions.microsoft.com> wrote in message
news:E11FD38E-1CAB-49CE...@microsoft.com...
0 new messages