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

"Dave Peterson" wrote:

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.



Marjon wrote:

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.

--

Dave Peterson