Make settlement single templateHow to fill in?
1) Determine the loan limit. In principle, the cost of selling the product of the product and the miscellaneous cost of the replacement of the same payment with the payment with the payment.
2) Regularly adjust the loan limit.
Put the text well in the unit, find the "Automatic Route" button on the toolbar to freely switch the text between changing and not changing lines.
2: Quickly select the formulation column
Select the form area, click "Create according to the selected content" dialog box under the [Formula] tab, select "First Line", set the name box in the upper left corner after setting, and click the corresponding list to jump to the specified column.
3: Format brush
The use of the format brush is very simple. Just click the format brush and then select the format to be copied. Finally, you choose a cell to be modified. You can modify it in batches.
4: Fill in the color interval to make the form more cool
Ctrl + t
First, use the shortcut Ctrl+Shift+right arrow+lower arrow to select the form, and then press Ctrl+T to achieve it.
The method of CTRL + T is very fast. It can quickly fill the form of the table, but it cannot achieve its own selected color.
Choose self -selected color filling method
First, use the shortcut Ctrl+Shift+right arrow+lower arrow to select the form. Then select the condition format in the start menu-new rules
Select the format to determine the cell that needs to set the format, and then enter the = mod (row (), 2) = 0 *0 in the format to indicate that the number of dwells is filled with
Then select the format button, open the fill tab, select your favorite color to fill
Xiaobian recommended by Huajun Software Park
Make settlement single templateIt is a very practical form, and most of the forms of filling the form are commonly used. If you just need to settle the payment single model, come and download it. also,Sotalwood recruitment requirements form,Summary table for unit trainee positionIt is also a good software, please click to download the experience!
it works
it works
it works