Excel - Wrap Text & Merge and Centre

Wrap Text & Merge and Centre

Wrap Text

Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break. But this will prevent you from a cell potentially taking up too much room on your worksheet. 

With the cell selected   "wrap text" can be enabled from the "home" tab: Illustrative image

Using Wrap text

First select the cell or cells you with to add "wrap text" to:

Then click the wrap text button:

As you can see the text has been pushed onto multiple lines instead of remaining very long and on one line. Sometimes you will receive an excel file in which someone has already applied this, therefore simply highlight all cells with CTRL + A and then deselect the box to revert everything back to standard. 

Merge and Centre

Microsoft Excel can use a tool called merge and centre to expand a cell's edges to incorporate surrounding cells. This can be used to make buttons or titles or for any other reason you might need to:


Here you can see a good example on the UK Metropolitan police data taken from the Data.police.uk website:  Illustrative image   

If you wish to create a similar parameters then you can use Merge and Centre to do so.

how to use merge and centre

Find the cell you wish to merge with others

Click and drag around the cell you wish to merge including the cell you wish to merge to:

Click the "Merge and centre" button

You may well want to mid-vertical align it too so that the text appear vertically central too: Illustrative image

This will make the text a little clearer and easier to read: Illustrative image

Still need help?