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

| Home | Excel 2003 Tutorials | Word 2003 Tutorials | PowerPoint 2003 Tutorials | Outlook 2003 Tutorials |
| Free Templates | Free Clip Arts | Free Tips & Tricks | Free Keyboard Shortcuts
|
| Excel 2007 Tutorials | Word 2007 Tutorials | PowerPoint 2007 Tutorials | Outlook 2007 Tutorials |
| Office 2010 Tutorials | Office 2003 Books | Win Vista Tutorials | Windows 7 Tutorials |


Microsoft Windows, Microsoft Office Word, Excel, PowerPoint, Access, OneNote,
Outlook and Publisher are either registered trademarks or trademarks of
Microsoft Corporation in the United States and/or other countries.


Return to Top | Privacy Policy

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