MULTI IN ONE: How to Merge Cells

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="leftMargin" style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin-left: 1em; margin-right: 1em; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
</div>
<br />
<div class="leftMargin" style="-webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin-left: 1em; margin-right: 1em; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<div align="left">
Study the spreadsheet below:</div>
<div align="center">
<img alt="An Excel 2007 Spreadsheet" height="201" src="http://www.homeandlearn.co.uk/excel2007/images/Review1.gif" width="336" /></div>
<div align="left">
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.</div>
<ul>
<li>Type the words <b>Shopping Bill</b> into cell A1 of a spreadsheet</li>
<li>Highlight the cells A1, B1 and C1</li>
<li>On the Alignment panel of the Excel Ribbon, locate the "Merge and Center" item:</li>
</ul>
<div align="center">
<img alt="Merge and Centre" height="87" src="http://www.homeandlearn.co.uk/excel2007/images/MergeCells.gif" width="274" /></div>
<ul>
<li>Click the down arrow to see the following options:</li>
</ul>
<div align="center">
<img alt="Merge Options in Excel 2007" height="92" src="http://www.homeandlearn.co.uk/excel2007/images/MergeCells2.gif" width="152" /></div>
<div align="left">
Click on "Merge and Center". Your three cells will then become one - A1, to be exact!</div>
<div align="left">
<br /></div>
<div align="left">
OK, now that you know how to merge cells, have a go at the following Review on the next page. It will test your new skills in Excel.</div>
</div>
</div>

How to Merge Cells

Study the spreadsheet below: If you look at Row 1, you'll see that the "Shopping Bill" heading stretches across thr...