How to make a printing template with bills

1. First, put the bottom plate where the template is to be set at the ratio of 1: 1 (which can be removed at that time) under the workspace as a "background picture" to facilitate size planning: menu bar-format-worksheet-background: select a picture-insert.

2. Adjust and merge the size of each cell according to the background picture, so that the settings are consistent with each cell of the background picture.

3. Select All Workspaces-Right Click-Format Cells-Protect: Lock (Check; Select cells to fill-Format cells-Protect: Lock (uncheck).

4. Toolbar-Drawing-Text Box-Insert a "Text Box" in any "Title" position and enter the title content.

5. Click the border of the text box-right click-set the format of the text box:

Color and line: there are "fill color" and "wireless bar color";

Properties: Size and Position Change with Cell (click) and Print Object (uncheck).

Margin: top, bottom, left and right "0 cm".

6. Copy the set text box to another location, and then modify the contents of the input title respectively.

7. After editing all the settings, hold down Shift to select each text box-right click-combination-combination.

8. Menu bar-Tools-Protection-Protection of worksheet-Enter password twice-OK (to prevent settings such as row height and column width from being changed).