Microsoft Excel: How to Centre Text Across Cells

Here is a handy tip to show you how to centre text across cells.

To learn more about formatting click here.

First you need to select the cells (as shown) and then right click on the cells.

Howt to Center Text Across Cells

Then click on ‘Format Cells’.

In the box that appears go to ‘Alignment’ and in the ‘Horizontal’ drop down box you need to select ‘Centre Across Selection’

how to center text across cells

Click ‘OK’ and then your text will be aligned to the centre.

how to center text across cells

If you want to learn more about Excel then take a look at our monthly courses in London and across the South of England.

To learn more about formulas within excel click here.