Hi Debra -

That worked. I'm not sure how I got 'un-enabled', but now I know where to
go to fix it.

Thanks for your time.

Marc

"Debra Dalgleish" wrote:

Make sure that selection is enabled:

Select a cell in the pivot table
On the PivotTable toolbar, click PivotTableSelectEnable Selection

Marc wrote:
no, it's not protected. It's a file that I created this morning. Did
something happen in the options?

"Roger Govier" wrote:


Hi Marc

Is the sheet protected?

--
Regards
Roger Govier



"Marc" wrote in message
...

Hey Roger -

I'm familiar with and use the method that you mention. However, all of a
sudden my cursor never turns into the solid black arrow.

Any thoughts?

Marc

"Roger Govier" wrote:


Hi Rob

Hover your cursor over any one of your subtotal rows, until you see a
solid
black arrow pointing right, then left click.
Apply whatever formatting you want, and it will be applied to all of your
sub-totals.

--
Regards
Roger Govier



"Rob" wrote in message
...

I have a simple pivot table that lists stuff. it lists States group by
region. On the region break of the pivot table (the summization line)
I
would like to shade and bold the font. Is there a way to do that
without
having to manually format each row... My concerning is if the data
changes
I
will loose my formatting.

Example:

NY 45.00
MA 450.00

Northeast regions 950.00 <-- I would like this line bold

FL 65.00
GA 27.00

Southern regions 92.00 <--- I would also like this link bold.









--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html