Prev: Simple Question Complicated Formula
Next: How do I insert a check box in Excel Vista? I'm a novice
From: Pebbs on 16 Dec 2009 19:39
Is there any way to insert subtotals (without jumping through hoops like
inserting rows and labeling them) into an Excel 2007 "Table"? When attempt
is made, the option is grayed out on the Data tab.

Any help (and/or workarounds) is appreciated!
From: Ashish Mathur on 19 Dec 2009 07:24
Hi,

You cannot do so. You will have to convert the table back to a range and
then use Data > Subtotal

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Pebbs" <Pebbs(a)discussions.microsoft.com> wrote in message
news:C2C43443-4DB4-4D10-9057-282C584A9121(a)microsoft.com...
> Is there any way to insert subtotals (without jumping through hoops like
> inserting rows and labeling them) into an Excel 2007 "Table"? When
> attempt
> is made, the option is grayed out on the Data tab.
>
> Any help (and/or workarounds) is appreciated!

 | 
Pages: 1
Prev: Simple Question Complicated Formula
Next: How do I insert a check box in Excel Vista? I'm a novice