Quantcast

Cell Merge Options in Excel 2002

Get the WebProNews Newsletter:
[ Business]

The Merge and Center button on the Formatting toolbar is now a toggle that can apply or remove center alignment and merge the selected cells. Excel retains only the upper-leftmost data in the selected range in the resulting merged cell. If there is data in other cells, the data is deleted.

Additionally, there are three new merge-related commands that can be added to the Formatting toolbar: Merge Cells, Unmerge Cells, and Merge Across.

Merge Cells: Combines two or more selected cells into a single cell. Excel retains only the upper-leftmost data in the selected range into the resulting merged cell. If there is data in other cells, the data is deleted.

Unmerge Cells: Separates a merged cell into the original number of cells

Merge Across: Combines the contents of selected adjacent cells in the same row into a single cell

Adding a Merge Command to the Formatting Toolbar

1. Choose Customize from the Tools menu, and then click the Commands tab.

2. In the Categories list, choose Format.

3. Locate the merge command you wish to add. Click on the Description button to read about the command.

4. Drag the icon from the Commands list to where you want it placed on the Formatting toolbar.

Beth Sunny and Karin Rex share their extensive knowledge in IT and training as freelance writers for http://www.SharperTraining.com. Don’t miss their training tips along with insights from other experienced trainers in SharperTraining.com’s “Focus On Training” newsletter. To subscribe, visit http://lb.bcentral.com/ex/manage/subscriberprefs.aspx?customerid=1468

Cell Merge Options in Excel 2002
Top Rated White Papers and Resources
  • Chris

    This is pointless, when it merges two cells it only keeps the data from the left cell… essentially all this does is delete the right cell… not technically merging the data together.

    Cell A= DataA Cell B = DataB

    A merged cell should be DataA DataB…. not just DataA.

  • Join for Access to Our Exclusive Web Tools
  • Sidebar Top
  • Sidebar Middle
  • Sign Up For The Free Newsletter
  • Sidebar Bottom