Home » Blogs » Nick's blog

65. Excel Tips - Center Text Across Cells

Nick's picture
Submitted by Nick on 30 March, 2009 - 13:02


This tip shows you how to center text across cells. Suppose you have the following arrangement, and you want the heading to span the whole table:

Center-Text-Across-Cells

One option is to merge the cells.. right click => format cells => Alignment => merge cells.

In my experience, merging cells is a really bad thing to do as it leads to various complications like -

* Not being able to sort the data easily

* Odd things happen with range names

* Sheet navigation gets messed up

 

A better option is to Center Across Cells: Select the cells (as shown), and go: right click => format cells => Alignment => Horizontal => Center Across Selection

Center-Text-Across-Cells

Download sheet to practise how to Center Text Across Cells in Excel

Training Video on how to Center Text Across Cells in Excel:

AttachmentSize
Center-Text-Across-Cells.xls18.5 KB
»

Thanks

Submitted by Anonymous on 7 July, 2010 - 08:19.

This option is very useful.

Keep up good work.

Regards,
A.Kalusalingam

»

better one

Submitted by Anonymous on 24 May, 2012 - 12:19.

Alt+H+A+C...to align the text in middle or where ever you want...

Thanks,
Rupali

»

Thanks for this tip

Submitted by Anonymous on 20 July, 2010 - 18:00.

I agree, very useful, I don't understand why excel has so many troubles with merged cells, the AutoFit is really bad, and also to see what is being merged/remerged.

The best approach was if we have something like left across selection or right across selection, because sometimes we want to merge only to see several rows, not to keep the text in the center...

Thank you!

»