How to Merge & Center Selected Cells in Excel 2007

Save

To aid in formatting of your spreadsheet, Microsoft Excel 2007 allows you to merge multiple cells into one and format it according to preference. This is especially useful when adding a centered title, which spans the width of your spreadsheet. Although merging works well for cell layout, it is not designed for merging of data within cells. When merging, only the text in the top, left cell will be kept; all other data is discarded.

  • Click and drag your mouse to select multiple, continuous cells.

  • Right-click any selected cell and click "Format Cells..."

  • Click the "Alignment" tab in the Format Cells window.

  • Check "Merge cells" in the "Text control" section.

  • Click the "Horizontal" drop-down menu in the "Text alignment" section and select "Center" to center your text in the width of the merged cells. Likewise, you can elect to center your text length-wise by selecting "Center" from the "Vertical" drop-down menu.

  • Click "OK" to accept your changes and close the Format Cell window. Your selected cells are then merged and centered.

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!