How does word make a pay bar? There are many ways to make payroll, including subtotals, VBA, skill sorting, and so on. Today I'll explain how to use Word to make a pay bar.
1. Create a new Word document and select "Mail"-"Start mail Merge"-"directory" command.
2, according to the contents of the Excel Payroll table in Word to create a figure below the basic salary bar.
3, select "Mail"-"Start mail Merge"-"Select Recipient"-"Use existing list" command.
4. In the pop-up Select Data Source dialog box, select the Payroll source file you created, and click the Open button.
5, in the pop-up "Select Table" dialog box, select the entire payroll, press the OK button.
6. Position the cursor to the cell under Name, click Mail-Write and insert field-Insert Merge field Drop-down button, and select the corresponding field in the pop-up Drop-down box, that is, name. In this way, you insert the corresponding fields for other blank cells. After the completion of the effect is as follows:
7, select "Mail"-"Finish"-"complete and Merge"-"Edit a single document" command, in the pop-up Merge to New Document dialog box, click the "All" option, and then clicking the OK button.
8, so the salary table is completed, see the effect of it!