Slider

How to Merge Existing Cells in Excel Spreadsheet

Date:2019-10-28 Author:Cordelia

When editing a spreadsheet in Excel, a wide header which takes up the width of several cells is often needed. In practice, we often merge some existing cells to fulfill this kind of demand. Let’s see the detailed steps.

1. Select the range of cells you want to merge. Please note that they must be conterminous cells.

This image has an empty alt attribute; its file name is image-26.png

2. Find Merge & Center in Home tab.

How to Merge Existing Cells in Excel Spreadsheet

3. Click it (or you can also select options in the pull-down list as you need). There will be a popping out window requires you to confirm.

How to Merge Existing Cells in Excel Spreadsheet

4. If the content in all the cells are all the same, then just click OK. But if the texts in each cells are different, you should be careful since merging cells only keeps the upper-left value and discards other values.

After confirmation, these cells have been merged into one large cell.

How to Merge Existing Cells in Excel Spreadsheet

5. Alternately, you can also right click the seleted cells and choose Format Cells in the menu.

How to Merge Multiple Cells in Microsoft Excel

6. Then switch to Alighment tab in the popping out window and check Merge cells under Text control. After hitting OK button and making the confirmation, the selected cells will be merged as well.

How to Merge Existing Cells in Excel Spreadsheet

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *