Free Online Tutorials on Spreadsheets

Merge and unmerge cells in Excel

When two or more adjacent cells are merged, one greater cell is displayed across multiple column and rows. To merge adjacent cells do the following steps:

1– Select more than one adjacent cell e.g. cell A1 and B1 below.

2– Go to the Home tab, select Merge & Center from the Alignment window.

Both cells A1 and B1 will merge into a larger single cell.

3– To unmerge, either press Ctrl + Z or go to the Home tab and select the Merge & Center option again.

Copyright © 2016 - 2019 | All Rights Reserved