LinkedIn facebook


Formatting - Centres Text Across Columns

When you need to centre text across cell, the most common method used would be the merge & centre tool. However merging cells could cause other problems when selecting a range or when trying to perform a copy and paste. I would prefer to use Centre Across Selection formatting than to merge cells. Assuming you want to centre the text MICROSOFT EXCEL (which is in cell A1) across from A1 to F1, select the range A1:F1, press CRTL 1 (to format cells), select Alignment tab and in the Horizontal drop down list choose "Centre across selection" and click OK. Done !!!