Center Across Selection - the Merge and Center alternative in Excel 2007 » Office 2007 Help

Help, tips, tricks and tutorials for Microsoft Office 2007 - The New Paperclip

Center Across Selection - the Merge and Center alternative in Excel 2007

15th April

2008

written by The New Paperclip

Do you need step-by-step Office 2007 instruction right at your fingertips? Get your Office 2007 Quick Source Guides today!

Yesterday I told you all about how you can use Merge and Center to get some text to run across a number of columns, rows, or both.

Well Jon Peltier quickly got onto the comments box and let us know about an alternative to Merge and Center in Excel 2007 called "Center Across Selection". It’s just like merge and centre, but without all the hassles that merging cells cause.

Center Across Selection is a little harder to find than Merge and Center, but in true The New Paperclip tradition… I am going to show you how!

Select your text and the cells you want to centre your text over.
On the ribbon, make sure you are on the "Home" tab, and then look for the "Alignment" group.
Click on the little square with the arrow in the bottom right hand corner of the "Alignment" group.
In the "Format Cells" box that appears, look for the "Horizontal" drop down box
Select "Center Across Selection"
Click "ok"
Look in amazement at your perfectly centered text