"How to Merge Cells in Excel 2007 and Vice-Versa?"

Study the spreadsheet below before we start our tutorial on merge cells in Excel 2007:

If you look at Row 2, you'll see that the "Items Price" heading stretches across three cells. This is not three separate cells, with a color change for each individual cell. The B2, B3 and B4 cells were merged.

To merge cells in Excel 2007

• Type the words "Items Price" into cell B2 of a spreadsheet.
• Highlight the cells B2, B3 and B4
• On the Home tab, in the Alignment group, locate the Merge and Center icon.
• Click the down arrow to see the following options:

• Click on Merge & Center. The three cells will then become one - B2, to be exact!

To unmerge cells in Excel 2007

• Click on the cell B2 (the cell that merged before).
• On the Home tab, in the Alignment group, click on the down arrow next to the Merge and Center icon.
• Select Unmerge Cells. The cell B2 is now separated into 3 cells.

Related Topics:

How to Edit Cell in Excel 2007 and How to Prevent it from Editing?
Discovering the Cells Alignment Options in Microsoft Excel 2007
Adding and Editing the Header or Footer in the Excel 2007 Worksheets
Formatting Number in Excel 2007

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the merge cells in Excel 2007 info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb