1. To make a spreadsheet, you need to find the "Table" column above the software.
How to use WPS to make tables
2. Click "Form" and the options of "Draw Form" and "Insert Form" will appear in the drop-down box that appears. Personally, I think it is more convenient to use the insert table.
How to use WPS to make tables
3. Set the number of rows and columns of the table to be drawn. Click OK and a basic table will appear.
How to use WPS to make tables
4. You can use other functions of tables to turn this basic table into a more complex table.
First of all, introduce how to draw the right corner. You can choose "Draw Tilt Title" as shown in the figure below.
How to use WPS to make tables
Then choose the header style to draw, and the header you need will appear after confirmation.
How to use WPS to make tables
How to use WPS to make tables
5. Sometimes it is necessary to merge several cells into one. You can select the cells to be merged first, and then right-click Merge Cells to merge several cells into one.
How to use WPS to make tables
How to use WPS to make tables
seven
Using the above basic operations, you can draw complex and changeable tables.
Tools/raw materials
computer
Wps form
Methods/steps
1
Right-click a blank area on the computer desktop to create a new blank form. And change the name of the form to a familiar name.
2
Open the form and enter the title of your own form in the first line (for example, business sales commission table).
three
Usually, the title needs to be at the top of all tables. At this time, you need to merge the table as shown in the figure, and click Merge Cells to achieve it.
Put the mouse over the capital letter symbol and you can see the black arrow pointing down. Click the mouse to select it to adjust the column. When you want to move a column away from its original position, you can select it, right-click it-cut it, then right-click it where you want to place the column, and select the cut cell to move the column. Place the mouse at the position of the number on the left to adjust the line. Row position adjustment is the same as column operation.
After entering the required data in the table, you can adjust the size, thickness and shape of the font as needed. The original table is a dotted line, and the table line will not be displayed when previewing and printing. You can click the border option to make the table solid, so that table lines can be displayed when previewing and printing. There are several options for this option.
When the text in the table can't be input, you can right-click the grid-set cells-select alignment-word wrap, which can realize word wrap and avoid text loss when printing.
Tables can also do simple formula operations. Take multiplication as an example. Put the mouse in the cell where the product of several products is located, press the keyboard equal sign key, and then use the mouse to select two or more cells to be multiplied. Click the multiplication key in the middle of each cell to indicate multiplication (if it is division, press the division key, the position of the keypad is marked with/,and other formulas are the same), and the phenomenon shown in the following figure will appear (B3*C3 as shown in the figure).
If you want the whole table to be like this formula, you can put the mouse in the lower right corner of the column and a black cross will appear. Hold down the left mouse button to drop down the cross, and the number will be displayed in the lower column. These numbers are the numbers obtained by multiplying the first two columns (that is, the numbers obtained by multiplying columns B and C). These formulas are used in many tables. When the numbers in the previous columns change, the positions of the numbers will change accordingly. Usually, we can keep the completed form and make a new form by directly changing the figures next time.
As shown in the figure, a small sign will appear after the drop-down table. The triangle next to the logo can have different options, such as copying cells or filling them in order, which can be selected as needed.
This function is usually useful when inputting numbers, such as 1, 2, 3, etc. When entering 1, press the cross in the lower right corner of the table to drop down, and the serial numbers 2 and 3 can be displayed directly in the lower box.
Sometimes the number of rows and columns in a table will be incomplete on the computer monitor, which will be inconvenient when making a table. At this time, we can use the function of freezing tables.
After the table is frozen, pull the table up, down, left and right, and the frozen part will not move. Frozen forms can be thawed at any time.
Click the preview button on the completed form to see the overall effect of the form. You can adjust margins, print orientation, and set headers and footers.
When you need to print, you can click Print.
How to make simple and practical forms with WPS forms _ Baidu experience: jingyan.baidu./article/6766299747a5dc54d51b84ac.
Please refer to:
:jingyan . Baidu ./article/6766299747 a5dc 54d 5 1 b 84 AC。
How to make Plato with WPS table? Ppt How to Make Plato _ Baidu with WPS Table Experience: Intensive Research. Baidu, please. /article/2a 13832890 168 f 074 a 134 f8a。
How to make resume forms and resumes with wps
Personal basic information
Name and gender
National date of birth
Political view of identity card number
Marital status and health status
Education major
native place
current location
graduated institutions
Job hunting intention and work experience
Job application by talent type
Working years and professional titles
Work Search Type Available Date
Desired working place
Work experience, working hours
name of the company
Corporate nature
hold a post
Task description
The reason for leaving
academic degree
Professional qualification of time college
Personal skills
english level
Computer level
Work ability and other specialties.
Hobbies and interests
contact information
Contact Phone Number Home Phone Number
E-mail postal code
How to make the duty table with Excle table? First, use strokes, think about styles, and adjust the width of the table according to the styles designed by yourself. Finally, select the finished area, right click-set cell format-border, select the black boxes with squares and crosses at the top, and save and exit.
The title of the first line, starting from the second line:
A2 Enter 09- 12-7.
B2~C7 respectively enter a round of names, such as:
Zhao Yi Chiji
Sun San Lees
Liu Wu on Friday.
Qian er Zhao yi
Liz Sun San
Wu
Select B2~C7 to fill downward.
A3 input = IF (Weekday (A2 A2,2) = 5, A2+3, A2+ 1) input and fill it down. The format of this column is set as: Date: X Month Y Day.