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.7 | 10 votes


Read More ...





Who's New

metaclippingpath's picture
Generalocee's picture
emma agro's picture
DarkkDdream's picture
Larisabrownb's picture
conor13's picture
MeadeDorianx's picture
Emilylowes's picture
Emmaythomson's picture
Chair's picture
Financial's picture
Red bud's picture
DonnaStella123's picture
WenrichFeugene's picture
Weissert's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2024
TOS | Privacy Policy