Monday, February 25, 2008

How to merge cells in microsoft excel?

This document explains how to merge cells in Excel.

Merging cells is often used when a title is to be centered over a particular section of a spreadsheet. When a group of cells is merged, only the text in the upper-leftmost box is preserved.
To merge a group of cells:
  1. Highlight or select a range of cells.
  2. Right-click on the highlighted cells and select Format Cells....
  3. Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells.
To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. Again, this will only preserve the text in the upper-leftmost cell.
  1. Highlight or select a range of cells.
  2. Merge and Center

  3. Click the Merge and Center button on the toolbar.


1 comment:

Alex said...

This morning I didn't see my excel files on the PC. I was disappointed, but soon I decided to use the Google. And was right. I detected - recovery for Excel on undetermined blog. The software worked out my trouble without even trying and I went for a walk.