Merge and Center in Excel 2007

Wonder how your favourite accountant/analyst/spreadsheet guru makes those cool looking headings that go across a number of columns and rows?

Chances are they are using a great feature of Excel 2007 called "Merge and Center".  What does merge and center do?  Exactly that – it merges all the cells you have selected, and then centres the text!

So how do you do it?

  1. Select the cells you want to merge
  2. In the ribbon menu (the one at the top) make sure you are on the "Home" tab, and then look in the "Alignment" section
  3. Select "Merge & Center"

Simple as that!

Have you selected multiple rows?  Well you will notice that whilst the text will be horizontally centered… it will not be vertically centered.  How do you fix that?  Just near the "Merge & Center" button in the menu there are three buttons.  One that has lines at the top, one that has lines in the middle, and one that has lines at the bottom (the one with lines at the bottom will be selected).  Select the one with the lines in the middle – that will center the vertical alignment of your selection.

’till next time!

TNP ;)

Technorati Tags: ,,

5 thoughts on “Merge and Center in Excel 2007

  1. A much better option is Center Across Selection, which gives the same visual result as Merge And Center, without the issues that merged cells can bring. Unfortunately, by the time we got the beta, it was too late to put Center Across Selection into the ribbon, so you have to open up the format cells dialog.

  2. Pingback: Center Across Selection - the Merge and Center alternative in Excel 2007 » The New Paperclip

  3. Hi All –

    In my everyday work life I often have to build plans in an excel sheet and I
    need to merge or unmerge cells. Is there a shortcut key to merge and unmerge
    cells without having to go to format cell and select the align tab, and then
    click or unclick the merge option?

    Sudhir upadhyay,
    Jharkhand

    Thanks!

  4. @Sudhir, in Office 2007, almost every button on the ribbons has a keyboard shortcut sequence that you can memorize for the commands you frequently use. If you push the Alt key once, you’ll see tool-tip pop-ups on the ribbons letting you know what the sequence is to go to the ribbon and then the button you want.
    For merge and center, you can press the character sequence: Alt,H,M,C
    and it is as if you had clicked on the Merge and Center button.
    For merge across, it’s:
    Alt,H,M,A

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>