For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classes
for the month of Jan, Feb, Mar, Apr 2022
Analyzing Data with Power BI
Microsoft Excel - Power Query (M365, 2021-2010)
Microsoft Excel - Power Pivot (M365, 2021-2010)
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 !!!