Changing Selection for the "Center Across Selection" alignment

J

johnandsuzie

I'm sure others must have had this problem. Hopefully someone can help me
fix it. When I format a cell as center across selection, it centers the info
over whatever area I had highlighted. But once I've done it once, I can't
figure out how to change the selection to center the text over.
For example, let's say I center A1 over A-H, then I delete the information
in column G and H and I only want to center the info over A-F. No matter
what I do I can't seem to change the selection.
I've tried highlighting the new area, and hitting "center across selection."
I've tried deleting the info and reentering it. I've tried left alighning
it, then centering it again. No matter what I've tried, I can't seem to
change the selection my text centers to. Thanks for the help.
 
C

Cutter

You just highlight the G1:H1 range and give it any other alignment
format. For example click on the left align icon, right align icon or
centre icon.
 

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

Prompt For Replace in Selection And More... 0
Center across selection frustrations 3
Active Content in this file is blocked issue 1
Need Help with Macro Security 1
Macro to Select text from a point given to a specific word 2
Center across selection 2
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top