All values are preserved while merging cells

A merged cell is a command that users use when making a table, and it can be used to beautify multiple cells as a single cell.

In general, if you combine several cells that contain data, Excel prompts you to "when you merge cells, if more than one of the selected cells contains data, Excel preserves the data in the upper-left cell and deletes all remaining data." "As shown in Figure 1.

Figure 1 Tips for Excel when merging multiple cells with data

This in many cases will make users feel embarrassed, the merger will lose data, affect the calculation of the data, and do not merge can not take into account the aesthetic. The following methods break through the limitations of Excel, preserving all values while merging cells. Assuming the table shown in Figure 2, you now need to merge a1:a4 and A5:a8 separately.

Figure 2 Table to merge cells

Select C1:C4 and click the Merge and center button in the toolbar. The same method merges the cells c5:c8, as shown in Figure 3.

Figure 3 Merging cells by the size of the destination area in a blank range of cells

Select C1:c8, click the Format Painter button in the toolbar, and then click A1 to format the copy. The result is shown in Figure 4. In this process, Excel does not show any warning.

Figure 4 Copy the format of the blank area to the target area

To verify that the merged cells retain their original data, you can use the formula in the D column to refer to the calculation and enter the formula in the D1:

=a1

Then drag to D8 for formula replication. The result is shown in Figure 5.

Figure 5 All values are preserved after merging cells

Note : More wonderful tutorials Please pay attention to the triple computer Tutorials section, triple Office group: 185219299 welcome you to join