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

KaylaMorgan's picture
arxeis77's picture
eyoungren's picture
RavingNutter1972's picture
Mridul's picture
Holyryan2346's picture
washim's picture
yeniban's picture
siam3933595's picture
al360's picture
militarymom's picture
Simra's picture
srikanth's picture
joshter1950's picture
bittu's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2017
TOS | Privacy Policy