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.