How Excel makes the pay bar
Example: As shown in the following figure, a pay bar is required.
Operation Steps:
Step 1: In the A10 input A3, and then select the A3:a5 area down drag, will copy a4,15,16 ...
Step 2: Select a column substitution, replace a with "=a", replace the word Fu Quan in column A with a formula, that is, =A3,=A4,=A5, and then select the column a formula to the right to all fields. All payroll data is copied and two blank lines are left under each line.
Step 3: Copy the header row, and then select A8:a22,ctrl+g Position-position criteria: null values. After positioning, you will select all the blank lines up and down of the payroll data, and then paste the line, and the effect is shown in the following illustration.
Add: The use of the sequence can be reproduced in a variety of features, can extend a lot of useful excel skills.