Subtotals (outline) features grayed out

[Rubystarx]

I need to use the outline/ subtotal feature and it is grayed out. I am using
Office 2007. How do I get the function to appear?

 

[BoniM]

I suspect you formatted your sheet as a table just for appearance sake.
Using the Format as Table button on the home tab does more than just apply an
autoformat tho. You can't apply Subtotals to a 'table' - under Table Tools >
Design on the Ribbon, in the Tools group, click Convert to Range. Subtotals
will then be available.

 

[Kelly Gates]

thanks that certainly solved my problem



Boni wrote:

I suspect you formatted your sheet as a table just for appearance sake.
10-Jun-08

I suspect you formatted your sheet as a table just for appearance sake.
Using the Format as Table button on the home tab does more than just apply an
autoformat tho. You can't apply Subtotals to a 'table' - under Table Tools >
Design on the Ribbon, in the Tools group, click Convert to Range. Subtotals
will then be available

:

Previous Posts In This Thread:

Subtotals (outline) features grayed out
I need to use the outline/ subtotal feature and it is grayed out. I am usin
Office 2007. How do I get the function to appear?

I suspect you formatted your sheet as a table just for appearance sake.
I suspect you formatted your sheet as a table just for appearance sake.
Using the Format as Table button on the home tab does more than just apply an
autoformat tho. You can't apply Subtotals to a 'table' - under Table Tools >
Design on the Ribbon, in the Tools group, click Convert to Range. Subtotals
will then be available

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Client-Side Real-Time Stock Quote ScreenScraping
http://www.eggheadcafe.com/tutorial...889-dce6a1077593/clientside-realtime-sto.aspx