It takes a lot of time and energy for a novice to make a form template by himself. Take Lu Zi as an example, an intelligent inventory management table has been made for a week, not to mention the more difficult ones.
Now I will teach you a little trick to get a beautiful form template as soon as possible.
But before that, let's play a thinking question. Everyone knows that Lu Zi's first interest is Excel, but few people know Lu Zi's second interest. You know what? Guess what?
Lu Zi began to contact financial management from 12, and none of the funds bought with fixed investment lost money. Participate in the financial essay competition and win the second prize. Unfortunately, it's not the first prize.
Now, let's take getting a financial management template as an example to illustrate.
You think Lu Zi can't do it by herself, then you are all wet.
When creating a new workbook, you can directly select a blank workbook or select various form templates. These form templates are used by Lu Zi. Now take the stock investment performance template as an example, and double-click it to open it.
After opening, you can see that many formulas are set in this template, such as this summation formula.
However, stocks are too advanced for ordinary people to play well. With my clever IQ, I failed miserably. If your IQ is higher than mine, you are welcome to go in and play a world.
If you want another form template now, in the new place, search for the keyword financial management, and then search, and the corresponding form will appear.
In addition to searching, you can also click to get the corresponding table template, such as budget, according to the default suggestions.
At this time, you will see all kinds of exquisite form templates, which are much more professional than the stock template just now.
That's all about form templates. It's simple. You can do it by hand.
Reader Qiao Keli: Our company has a form template, which can only be saved as, not saved. How to do this?
Select the table you want to use as a template, right-click Properties, and select Read Only.
Now as long as you modify the original table and save it, a warning dialog box will pop up and you can only save it as.
Have a try after reading it!
End.
Source: Excel does not work overtime