Thread: Subtotal function is greyed-out - can't insert
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote
 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.
Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.