Skillfully handle complex Excel tables with multiple merged cells

Excel is a very powerful form processing software, especially its table computing ability, convenient, fast and automated operations, so that more and more people choose to use Excel to deal with day-to-day office forms. However, when encountering some "irregular" forms, many beginners find it very tricky. Table "Irregular", mainly as a combination of cells too much, cell or up or down, or left or right, complex or even multiple rows, multiple columns are not aligned. For example, the Sino-US MBA application form in Figure 1:

Figure 1

Look at the table and see that the title cell and gender cell are misaligned, cell phone and industry are not aligned, the right side of the corporate nature and the left side of the e-mail line are misaligned, and so on. Many beginners are accustomed to "gender", "job", "Cell phone", "industry", "ZIP Code", "Home Phone", "Office Telephone", "Enterprise Nature", "e-mail" all according to 1 rows 1, "Photos" by 4 rows of 1 columns to calculate, made out of the table result is: "Gender" and "job "Up and Down," "mobile", "industry", "postal code" up and Down, "Home phone", "office Phone", "Enterprise Nature", "e-mail" up and down, regardless of how we adjust the column width, the above cells are aligned, can not achieve the form we want to effect. See figure below:

Figure 2

So, in the end how to achieve the effect of the upper and lower misalignment?

In fact, we now take the "gender" and "job" as an example, and when "gender" and "job" are aligned, these two cells Occupy 1 rows of 1 columns (see Figure 2), and when they are not aligned, the attentive person quickly discovers that their ranks have changed and that, for the convenience of the reader to observe, We draw the left and right lines of the two cells in Figure 1 with a dashed line, and the effect is as follows:

Figure 3

When "gender" and "title" are not aligned, "gender" before the space, "gender", "title" is accounted for 1 rows 2 columns, "title" After the space for 1 rows of 3 columns.

Therefore, we can insert 1 columns before and after the "sex" cell in Figure 2 table, the effect is as follows;

Figure 4

Then, the "gender" of the first two spaces merged, "Gender" to the right to merge 1, "title" to the left to merge 1, "title" After the two spaces merged, the effect of the following figure:

Figure 5

By adjusting the corresponding columns in the previous illustration to the appropriate width, you can achieve a "gender" and "title" misalignment. See figure below:

Figure 6

Using the same approach, the "industry" and "mobile", "Corporate nature" and "e-mail" are adjusted to the top and bottom of the line, you can complete the production of the entire form. The effect of the following figure;

Figure 7