Categories
Excel Training

How to Merge Cells in Excel 2010

Merge Cells in Excel 2010;

Study the spreadsheet below:

An Excel 2007 Spreadsheet

If you look at Row 1, you’ll see that the “Shopping Bill” heading stretches across three cells. This is not three separate cells, with a colour change for each individual cell. The A1, B1 and C1 cells were merged. To merge cells, do the following.

  • Type the words Shopping Billinto cell A1 of a spreadsheet
  • Highlight the cells A1, B1 and C1
  • On the Alignment panel of the Excel Ribbon, locate the “Merge and Center” item:

Merge and Centre

  • Click the down arrow to see the following options:

Merge Options in Excel 2007

Click on “Merge and Center”. Your three cells will then become one – A1, to be exact!

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.