UtterAccess.com
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    
 
   
awinscott
post Apr 16 2018, 12:12 PM
Post#1



Posts: 49
Joined: 12-April 06



Hi,

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
 
dflak
post Apr 16 2018, 04:16 PM
Post#2


Utter Access VIP
Posts: 6,185
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.

--------------------
Dan

One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
Please zip and attach samples. It makes life easier for those who have to figure out what you are trying to do. Thanks
Go to the top of the page
 
awinscott
post May 9 2018, 01:30 PM
Post#3



Posts: 49
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 August 2018 - 06:11 PM