PivotTable: how to align row data to the left?

B

blackpuppy

After dropping a field into the Row Fields area, the row data will be
aligned in the center. But since it is text, I want to align it to the
left. How to do that? I guess it's no use just changing the cell
formatting.

Thanks!
 
B

blackpuppy

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Align the form to the top left 5
align autoshape with centre / right of excel cell 2
Save As HTM with "align=Left" in HTM file code 2
Align to the left or to the right (or center) 2
Excel Help to copy information from one row at a time to another sheet 1
find string in web page 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to align the <hr> element to the left? 7

Top