Problem: the content of a column is stored in the merged cells, and each merged cell is composed of four cells. Q: Can I cancel merging cells and require that the contents of the cells before merging be retained in all cells after the merging be canceled? Solution: 1. Select this column, click format cell in the menu to align, and click the box before [merge cells] to make it blank and confirm to exit. 2. Select this column, click Edit> locate in the menu, select a null value, and exit. In the editing column, enter "= ", enter the cell address of the first record in the column after the equal sign, and press Ctrl + enter. If this column is column A and the first record is in A1, enter "A1" after the equal sign ".