Merged cells break sorting and tables—use a macro to apply Center Across Selection with one click instead.

Right-click the Excel 2003 cell containing the text and select "Format Cells." Click the "Alignment" tab in the Format Cells window. Click the box next to "Wrap Text" to place a check-mark in it.

The Wrap feature wraps text into multiple lines so that you can see all of it, meaning that if there is a sentence in a cell which starched across the column to other columns in the spreadsheet, you ...