How to use excel form to make accounting vouchers

1. First enter the title and related items in the worksheet, as shown in the figure:

2. Enter the date in cell B2, and change the cell format to date format, such as Picture:

3. Define a name for the account code: switch to the worksheet where you created the accounting account before, and click Custom Name in the formula shortcut menu, as shown in the picture:

4. Pop-up dialog box, enter the first letter "kmdm" of each word of "account code" in the name column, and enter "=accounting account!$B$2:$B$26" in the reference position. The purpose of this is to set data validity .

5. Return to the accounting voucher worksheet, select "c5:c21" (that is, the account code column), click Data Validity under Data, select the settings page in the pop-up dialog box, and click Allow Select the sequence in the drop-down list, enter "kmdm" in the source text box, as shown in the figure:

6. Click OK to return to the worksheet, select any cell in the account code area, and click There is a down arrow button, and these account codes are all in it.

7. Enter the account code and use the mouse drag method to copy the formula to other cells, as shown in the figure:

8. Enter various data into the table. Enter the "sum" formula into the total horizontal cell, modify the result into RMB form, and complete the rendering.