How to quickly implement merge techniques in Excel

Here is a quick implementation of the integration skills, specific steps:

1, first of all, we look at the overall situation of the data, classification is confusing, the user is also confused, how to organize this kind of data, this is what we will do next work. Incidentally, it comes with a piece of the effect we want to achieve.

2, we first select the data area, select "Data"-"sort", we first sorted by category.

3, after sorting, we select "Data"--"subtotal".

4, here, we use the classification for the summary.

5, according to the subtotal, we choose "edit"-"positioning", or directly ctrl+g, call out the positioning function.

6. We first position the null value to facilitate our merging.

7, and then we use the merge in the Small toolbar to merge the Excel cells where the null values are located.

8. After merging, we found the data that can be used to make the source of the format.

9, we select the summary of this column, and then click on the format brush, mainly used in the format of this column.

10, and then click on column B, the format of column A is copied to column B, note that this is only a copy of the format, not the copy of the data.

11, we next is to clear the no action of a column, it has completed the task, first of all, we want to select a column of data. Pull up the positioning function.

12, then we select "Constant", cancel the number, the logical value, the wrong tick.

13, then we will locate the data to delete.

14, here we choose to delete the entire line, because this line of the whole is not what we want, so to delete.

15, after the classification of cell style adjustment, there is the effect we want, here I just use the alignment of the horizontal center.