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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
I would guess that the OP was talking about
format|cells|alignment tab|horizontal dropdown
center across selection.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Centre across selection' format to apply to vertical range 3
"Centre Across Selection" and character limit 1
Centre Across Selection oddity 2
centre across selection shortcut 3
Service Centre Database Help 0
how do i centre headings accross the screen in excell? 1
Formatting styles with centred text and tabs 2
merged cell wrap text autofit issue 3

Back
Top