Glide Training Logo

The Perfectly Centred Heading In Excel


Written by Jane Hames

In Excel you can centre values within a cell, merge cells and centre values within those cells, but my preferred option is the one that I often get asked about – Center Across Selection.

Center Across Selection, centres values across a range of cells. The advantage of this option is that you don’t have to merge the cells into one big cell. The value still remains in its original cell, it just appears centred across your data.

From this:


You get this:


Here’s how:

  1. Starting with the cell containing your data, select the cells it will be centred across.
  2. Click on the Alignment dialogue box launcher arrow.
  3. alignment button

  4. From the Horizontal Alignment drop down list, choose Centre Across Selection.
  5. format cells

  6. Click on OK.

previous post: Using Transpose in Excel to rotate data

next post: One space or two? A clever use of Find and Replace in Word