"centre across selection" moves

[Excel_Qs]

Hi, I have selected "centre across selection" to have text sit in the middle across several columns without merging cells. However when I press F9 to refresh, the text moves left and right depending on which cell I have selected when I hit F9. How can I make sure the text doesn't move and sit in the middle at all times?
Can't find solution anywhere on the internet. Please help! Thanks.
P.s. I have "wrap text" on the cell.

 

[Andrew Poulsom]

Welcome to MrExcel.

I can't reproduce the behaviour you are seeing. Do you want to put your workbook on a share like Box.net so that we can take a look?

 

[Excel_Qs]

Hi Andrew. Yes please. I have saved the workbook here https://app.box.com/s/thtdgfr27cgjhrjgrq0h
Title in cell B2 is what I was referring to. I have manual calc on and everytime I hit F9 to refresh the title moves.
Thanks!

Welcome to MrExcel.

I can't reproduce the behaviour you are seeing. Do you want to put your workbook on a share like Box.net so that we can take a look?

 

[Andrew Poulsom]

Still not happening for me, sorry.