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

paeltc's picture
dimpy123's picture
dfuller4747's picture
Bob the Observer's picture
Skalski5's picture
quattro2468's picture
davidclay123's picture
Sunny's picture
ZDooX's picture
Miamihot2007's picture
Fred McBen's picture
Sri's picture
bammer's picture
akay's picture
r1sc's picture
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop 2009-2017
TOS | Privacy Policy