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.
Q. I would like to accent the columns of my dataset by showing the headers diagonally. Is that possible in Excel? A. Want to make text stand out in your spreadsheet? Or just want to try some different ...