How to Make an excel Bookkeeping Form _ How to Make a Bookkeeping Form

The first step is to create an EXCEL table on the desktop and name it.

The second step is to edit the content. The third step is to add a border and set the most suitable column width.

1. Set the border, select the place where you want to add the border-right mouse button-cell format, then set it as shown below and click OK. (Actually, you can use shortcut keys, but I won't take a screenshot of the drop-down part, so I use the following figure instead. )

According to the confirmed appearance:

For the sake of beauty, let's merge the first row into cells, select A 1-F 1 and press the button (merge cells).

Then, center the font in the second line and make it bold. Modify the font size. What it will look like after completion:

2. Let's format each column.

Column A date, select column A-right mouse button-cell format-number-date-choose what you like.

Column b, just distance it, because if you want to write content, just set the font to be left-aligned.

C, don't move yet

Columns D, E, F, E and F are all currency format selection settings, with or without RMB symbol optional. Set as follows

After everything is set, I'll enter some contents and show you the format:

Of course, this font, size, grid width and so on can be modified by yourself. According to the above picture, we can see the date breakdown, expenditure and income. As long as we input it, its format has been fixed, which is very convenient.

Careful people will ask, why is there no balance? Yes, now let's balance.

First of all, when you make an account for the first time, count your cash (such as 500 yuan), enter this number in F3, and then F4 = F3+E4-D4.

Ok, then press enter, and the result will be:

After the results come out, you don't need to set each grid like this, just click the F4 drop-down button.

Now, let's write the total in the details of the last line. Expenditure and income automatically add up and press enter.

Well, the basic framework comes out. You can keep accounts on it.

After the above cash form is completed, let's make the second form: the credit card form. This is very simple. There is hardly anything to say.

1.

Select fifteen rows and three columns on the right side of table 1 and add a border (the specific rows and columns are actually arbitrary).

This picture is a bit big, mainly to show you the specific location, so I won't enlarge it later, just put it in the form of a credit card. Of course, if you don't want to put it in this position, you can. This is not particular.

2.

Enter a credit card in the first row, and then merge the cells.

Input in the second line: last month's consumption amount, repayment amount and balance in the card, with words in the middle.

The third line is temporarily motionless.

Input in the fourth line: this month, consumption amount, summary or detail, with text in the middle.

Then the outermost border is bold.

3.

Let's set the format

First, all three columns are set in currency format, and then the formula = i4-H4 is set in the next box (J4) of the card balance in the third row.

Ok, now let's enter the content to verify it.