"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:


Excel 2007 Sample Worksheet

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:

Excel 2007 merge and center

  • 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?

How to view, create and freely download the Excel 2007 template files?

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: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.