PivotTable: how to add vertical lines in Data Item area

After I drop a field in the Column Fields area, there are multiple
columns in the Data Item area (the main area for the numeric data).
How to add vertical lines in this area?

Thanks!

format the cells.

--
Regards,
Tom Ogilvy


"blackpuppy" wrote:

> After I drop a field in the Column Fields area, there are multiple
> columns in the Data Item area (the main area for the numeric data).
> How to add vertical lines in this area?
>
> Thanks!
>
>

format the cells.

--
Regards,
Tom Ogilvy


"blackpuppy" wrote:

> After I drop a field in the Column Fields area, there are multiple
> columns in the Data Item area (the main area for the numeric data).
> How to add vertical lines in this area?
>
> Thanks!
>
>

I tried this out. Once I refresh the data using menu Data --> Refresh
Data, the formatting will be gone.

Sorry, I didn't state my scenario completely. I am using a .NET
WinForm app to control the Excel programmtically. The data will be
generated as XML and imported into Excel. So every time, I need to
refresh the data.

Any other ideas?

Thanks!