How do I get "centre across selection" to centre properly?

[Guest]

I was using excel and tried centering the name of my table across a selected
amount of rows, which normally works but it just would not centre properly.
Can anyone help me figure out what I am doing wrong? I went into cell
format, then text alignment, chose Horizontal and clicked on centre across
selection but it just won't centre properly.

Would really like your help in solving this problem.

 

[Guest]

Check if any of the cells in your selected range contain some entry. Even a
space or an empty string will completely foul up that feature

 

[Dave Peterson]

Sometimes, I'll have this problem when I've inserted more columns to the
right/left of the original range.

I cheat and put something in those surrounding cells.

And then center across selection seems to work.

If I recall correctly, sometimes I've deleted that row and just started from
scratch.

 

[Guest]

I do a 'merge and center'. Is this what you are talking about?

 

[Dave Peterson]

I would guess that the OP was talking about
format|cells|alignment tab|horizontal dropdown
center across selection.

 

[wjohnson]

I have found that sometimes if I select the a column and try to center
if there are some cells which are left, right or already centered th
column WILL NOT change until I select the LEFT, RIGHT or CENTER
second time