X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Trouble Keeping Data Columns Centered In A Pivot Table, Office 2013    
post Apr 16 2018, 12:12 PM

Posts: 52
Joined: 12-April 06


I am having troubles keeping my data columns centered in a pivot table. I click the "center" icon and excel dutifully centers the data. But as soon as I change any filters in the pivot table the centering is lost.

I have attached a screen shot that visually displays the problem. You can see the data is not centered. I drew red arrows to show where the data should be located if excel retained the "center" command.

I also attached my excel spreadsheet so that anyone interested can test and verify the problem. Version 2013.

I appreciate any input or recommendations.
Attached File(s)
Attached File  Capture.JPG ( 40.44K )Number of downloads: 0
Attached File  Sample.zip ( 163.77K )Number of downloads: 3
Go to the top of the page
post Apr 16 2018, 04:16 PM

Utter Access VIP
Posts: 6,253
Joined: 22-June 04
From: North Carolina

This sounds stupid but it works for the Cell B8 (Entry time) select All and center the cell manually. Then select a time and center the cell manually. This cell seems to behave itself after that.

For Cell B12, select each of the entries and center the cell manually. It seems to behave itself after that.

I haven't got a clue why this works.
Go to the top of the page
post May 9 2018, 01:30 PM

Posts: 52
Joined: 12-April 06

Hi Dflak,

I tried your recommendation but it only kept the cells aligned temporarily. After enough changes to the desired filters the centering was broken.

The good news is I believe I have found a solution!

1) Right mouse click the desired cell
2) Select "Format Cells"
3) Select the "Alignment" tab
4) In the "Horizontal" field select "Center" from the drop down menu.
5) Click "Ok"

Pivot Tables apparently do not cooperate with the "Center" button on the Excel Ribbon.

But the manual steps listed above are working so far for me.

Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    17th January 2019 - 06:13 PM