User Login

Help Community Login:

Center Text Across Selected Cells Without Merging Cells in MS Excel

missb's picture
missb
Banned Member (Way To Go!)
Relationship Status:
Single & Not Looking
Joined: 01/16/2009
Posts: 3109
Drops: 3812
Mood: Weird

For those of us who use MS Excel there are a lot of times you may want to have report headings centered across the top of the page. The only way you used to be able to do this was to use the Merge and Center option. Although Merge and Center serves its purpose, it can cause other problems down the road, such as selecting ranges or copy and pasting ranges.

Here's how to merge text across selected cells without actually merging those cells. So say you want to center the following, "Sales For First Quarter 2010" across columns A, B, C, D and E. First, highlight the columns that you want the text to be centered over as follows;



In Excel 2007 go to the Home tab and click on the dialog launcher arrow in the bottom right hand corner of "Alignment".



Once there click on the "Alignment" tab on the Format Cells dialog box and select "Center Across Selection" from the Horizontal dropdown arrow and click OK


You text will now be centered but the cells will still be individual cells.

For Excel 2003 users, from the "Format" menu choose Cells. Click the Alignment tab on the Format Cells dialog box and select "Center Across Selection" from the Horizontal dropdown arrow and click OK.

I Averaged: 3.6 | 9 votes


Read More ...





Who's New

ritacastillo's picture
WiredWilly's picture
JoeBAR's picture
umedsingh's picture
anthonys's picture
carota's picture
tina's picture
erixisverizon's picture
Marshen31's picture
bashir1464's picture
E0nW0lf's picture
asDewt2354 tnw3's picture
SamCritch's picture
part's picture
tricoat's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2018
TOS | Privacy Policy