How to center a title across a range of cells in Excel ?

  • Thread starter Thread starter Guest
  • Start date Start date
Format>Cells>Alignment and Center Across Selection in the Horizontal box.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Anne,

The button you describe is the Merge and Center button, and is considered
more trouble than it's worth. You have trouble with selections, pasting,
getting seeds out of your teeth -- all kinds of stuff, which shows up later
long after you've forgotten you even used merge and center. Better is Bob's
suggestion of Format - Cells - Alignment - Center across selection. You
select the cells (that you'd have merged), then use that command. Put the
stuff you want to appear in the selected range into the leftmost cell.
 
You must log in or register to reply here.

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

Center across selection frustrations 3
Center across selection 2
Justifying text across a range of cells Excel 2007? 5
TOOLBAR button or Keyboard Shortcut FOR Center Across Selection?? 13
Numbers showing Up Centered in Cell ? 1
Is this a bug? 2
"justify across selection" cell formatting 6
Center All Pictures in Excel Cells 1

Back
Top