Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal function is greyed-out - can't insert
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal function is greyed-out - can't insert
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 On Wed, 9 Dec 2009 08:19:01 -0800, jmcclain wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal function is greyed-out - can't insert
By chance, is your workbook a 'shared workbook'?
Tools Shared Workbook Uncheck the little box OK HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "jmcclain" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal function is greyed-out - can't insert
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert menu greyed out | Excel Discussion (Misc queries) | |||
subtotal greyed out when in column | Excel Worksheet Functions | |||
My Insert Charts Buttons Are Greyed Out...Please Help | Charts and Charting in Excel | |||
Insert Rows option greyed out | Excel Discussion (Misc queries) | |||
Why is the menu item "Insert - Name" greyed out? | Excel Discussion (Misc queries) |