How to use computer office software to make forms
1. Right-click the desktop, and various options for creating a new excel file will appear.
2. Then select the imaginary rows and columns (pay attention to add a row title), and right-click the cell format.
3. Choose the appropriate boundary as envisaged. The top three are to set the border mode, from which you can choose one.
4. After choosing a suitable border, there are various borders here. Click OK.
5. Select the cell in the title box in your imagination, and click "Center after merging". Enter the prepared words in rows and columns, and a simple table will be made.
How to make this form with office software? Detailed steps
As long as you know how to merge cells, whether in WORD or EXCEL, it is quite easy to make this table.
A, using WORD form.
1. Select to insert the table, and determine the number of rows and columns required by the table (especially the number of columns, the table is12);
2. Enter the title (a group of four columns, and after entering a group, you can use copy and paste to complete the titles of other groups);
3. Manually adjust the width of each column;
4. If the specification and quantity corresponding to the name are known in advance, you can first select the cells under Name (single row) and select Merge Cells in the table layout; If you don't know the specification quantity corresponding to the name in advance, after entering the product name under the name, directly enter the specification corresponding to the product under the specification, and then select the number of cells under the name (the number of rows in a single column) according to the number of rows corresponding to the specification, and select the merged cells in the table layout.
Second, using EXCEL to make tables.
1, enter the title (a group of four columns, and you can copy and paste the titles of other groups after inputting one group);
2. Manually adjust the width of each column;
3. If you know the specifications and quantity corresponding to the name in advance, you can first select the cell under the name (single row number), align and merge, and then click Center; If you don't know the specification quantity corresponding to the name in advance, after entering the product name under the name, directly enter the specification corresponding to the product under the specification, then select the number of cells under the name (single row number) according to the row number corresponding to the specification, align and merge, and then click Center.
Office software table making
1, the newly created text after opening EXCEL is called workbook, and each workbook contains several worksheets.
Sequential filling in intelligent filling: write an initial value first, and then set a step size in the second cell for sequential filling (for example, if the initial value is 1 and the second value is 2, the step size is 1).
Formula filling: first make a formula object, and press down to fill it directly.
Number Type: Generally, when entering data, the number type should be set first.
Automatic summation of numbers: function-common function-summation-determination in point insertion (this demand requires high changes in functions)
Freeze Cells: Click Format-Cells-Align-Merge Cells-and then click Window-Freeze Window. 2. Do diagonal classification in the same title box of the table/can you make a frame specimen and generate the same arrangement horizontally or vertically based on it (with the function of automatic formatting)? Click this function. I hope it helps you.
How to make a form on the computer
The specific steps of making a form on a computer are as follows:
The materials we need to prepare are: computer, Word document.
1. First, we open the Word document.
2. Then we click to open the inserted "table" in the pop-up window.
3. Then we select the number of rows and columns in the pop-up window and click Insert Table.
How to make a table with wps table
1. Right-click a blank area on the computer desktop to create a blank form.
Change the table name to a name you are familiar with. 2. Open the form and enter the name of the form in the first line (for example, business sales commission).
3. The common title needs to be higher than the sum of all tables. In this case, you need to merge these tables as follows.
To do this, click the merged cells. 4. Put the mouse on the capital letter, and you can see the downward black arrow. Click the mouse to select the column to adjust. When you want to move a column away from its original position, you can select the column with the mouse, right-click-then right-click the position where you want to put the column, then select the cell to insert and cut to move the column.
You can adjust the line by placing the mouse on the number on the left. Row position adjustment is the same as column operation.
5. After entering the required data in the form, you can adjust the font size, thickness and shape as needed. The original form is a dotted line.
Do not display table rows during preview and printing. You can click the border option to solidify the table so that it can be displayed when previewing and printing.
There are several options for this option. 6. This table can also be used to perform simple formula operations.
Friends in need can refer to the experience of Xiaowen quoted below, which describes how to add a calculation formula. 7. A small mark will appear after the drop-down form.
The small triangle next to the label can have different options, such as copying cells or filling cells in order. You can choose according to your needs.
This function is usually useful when entering numbers, such as 1, 2, 3, etc. When you enter 1, press the cross in the lower right corner of the table to display the serial numbers 2 and 3 directly.
8. Sometimes, the number of rows and columns in the table on the computer monitor is incomplete. It's inconvenient to make a table.
In this case, we can use the function of freezing the form. 9. After the template is frozen, drop the table left and right, and the frozen part will not move.
Frozen forms can be thawed at any time. 10. Click the preview button of the completed form to see the overall effect of the form.
You can adjust margins, print orientation, and set headers and footers. 1 1. Click "Print" when you need to print.
How to make a watch with WPS?
Hello, I'm glad to answer your question!
In WPS text, you can draw a table by choosing the Table command on the Insert tab.
After inserting the table, click the table to add two tabs: Table Tools and Table Styles.
This is the basic process of making a form, and the use of specific commands depends on the requirements of the form.
It is recommended to study in WPS official forum.
Paper typesetting, template downloading, paper problems, solutions :docer.wps/zt/lunwen? . from = qyzd
For more WPS office software tutorials, please visit bbs.wps or e.weibo/wpswfw..
If you have any questions, please click on my avatar to ask questions. Wish you a happy life!