1. How to make a salary table
1. Sorting method
Enter serial numbers such as 1, 2, 3,,, in the auxiliary column, Then copy this sequence to the line below.
Paste the header row with the same number of rows under the table, and then sort according to the auxiliary column.
2. Insert row method (single row title)
Enter the number diagonally in the auxiliary column, then locate the constant and insert the entire row.
Then copy the title row, locate the null value in column 1, and paste the title row.
3. Insert row method (double row title)
If the title row contains 2 rows of titles of merged cells, after dragging in the row, position the insertion row again, and then paste it .
To insert a blank line, see method 2
4. Replacement generation reference method.
Copy the reference location, replace it with the formula reference, and then paste the title row.
5. VLOOKUP function method.
Copy the title row to row 8 - enter 1 in column 1, then enter the formula in column B and copy to the right
=VLOOKUP($A10, $A$1:$ G$6, COLUMN(B1),0)
Finally, select the title row, formula row and blank row, and drag them down to copy.
2. How to make a salary table
1. Right-click the blank area of ??the computer screen, move the mouse to the "New" position, and click
"Microsoft office Excel 2007 worksheet".
Click the worksheet, and a blank worksheet automatically named "New Microsoft Office Excel 2007 Worksheet" is created on the desktop.
2. Double-click this worksheet to enter the worksheet interface and perform specific operations.
Set the first row as the header and name it "Employee Salary Table": Select columns A~H.
Click "Merge and Center" on the toolbar, and then enter the five words "Employee Salary Table".
3. Select the first cell in rows 2 and 3 of column A, and then click the "Merge and Center" button on the toolbar.
Enter the two words "Project", then press the "ALT" and "Enter" keys on the keyboard to change the line, and enter the two words "Name".
4. Click the "Left Center" button on the toolbar to adjust the width of the cell.
Then, double-click the cell to enter the editing state, hit the "space bar" on the keyboard to move the word "project" to the right, so that it is moved to the far right.
5. Click the "Insert" button on the toolbar, click the "Shape" button, and select a straight line.
Then, pull the straight line diagonally to draw a line.
6. Use the merge function to merge the cells that need to be merged separately.
Select the cells you need to use starting from the second row and click the "Border" button on the toolbar to add a border to the table.