Current location - Recipe Complete Network - Catering franchise - How to build a table template in wps? How to use wps to quickly create a table
How to build a table template in wps? How to use wps to quickly create a table
wps in the new table style in Excel tables, often apply the table style, but the table style that comes with it is not satisfied, how to create a new table style? First of all, open WPS, click on New and then click on the form, and then select New Blank Document at the bottom. After entering the production of the form page, click the start menu bar in the table style tab, in the pop-up page, select the new table style, in the new table style interface to set the first name; and then select the table elements to the entire table, for example, click the Format button. In the pop-up cell format dialog box, set up glyphs and other text styles; switch the border, you can set up to add the outer border style and internal style, select other elements, such as the first line of the stripes, click the format, in the pattern option to set up the cell backing; other elements in the table set up into their own style, just repeat the above operation, and finally select our table, click on the table format, click to select the customize the table, observe the pop-up option box content is correct, click OK, has been applied to set their own table style. How to use wps to quickly create a table

wps table to start basic tutorials are as follows

1, open the wps software, click on the top of the table, and then click on the new blank document.

2, into the wps form, select 10 rows and 6 columns of cells as an example, find the beginning of the field under the same symbol for the cell plus the border line.

3, then select the first line, use the merger of the sentence, in the input of a summary of the word can also be added to the background color.

4, in other blank cells to enter their own data can be, a simple wps form is done.

Simple form does not apply if you can create a new time, the use of wps recommended templates, but some of the recommended free some of the members need to use, you can find yourself to find their own on the line, wps shortcut to create a new form of WPS form is a form of software, and EXCEL software is very similar.

how to do with the computer wps form 1.wps how to do form wps how to do form computer wps how to do form 1, first of all, open the wps form, create a new blank form; 2, and then, in the new form, enter the table header; 3, and then, merge the form, as shown in the figure, select the cells to be merged, and then click on the top of the "merge! center" can be achieved; 4, then enter the contents of the table, as shown; 5, and then select the form, click on the icon shown in the figure, and then in the pop-up box, click on the "all the lines"; 6, and then, select the form, click on the location shown in the figure can be set to the font and size; 7, and then select the form, click the right mouse button, and then click on the right mouse button, and then click on the right mouse button, and then click on the right mouse button, and then select the form. Form, click the right mouse button, in the pop-up box, click "Set Cell Format"; 8, then, in the pop-up dialog box above the click on "Alignment", and then in the "Horizontal Alignment "box, select" center "; 9, and then, click on the" preview "icon, you can see the good form.

Extended information:

Using the computer wps to do form skills: many times we are unable to avoid the computer crash or power outage and other special circumstances, and in order to avoid these emergencies in the office, resulting in our documents or forms are not saved, it will be our loss, so be sure to set up a regular backup function. When the form data is too large, we can create multiple groups for it, when viewing the data, just expand it, very convenient. Quickly select contiguous areas. First of all, we select one or more consecutive cells, hold down the Shift key on the keyboard and do not let go, with the cursor click on the cell borders (you want to select the left side of the continuous region, that is, the cursor will be moved to the left side of the cell borders double-click; you want to select the right side of the continuous region, then, the same will be the cursor moved to the right side of the cell borders double-click). How to make the simplest form in wps themselves in wps to make the simplest form of the specific steps are as follows: 1, first of all, we open the computer excel software to open a form, in the first line of the form of the name, such as business sales commission table. 2, the general form of the table header needs to be listed in the form of all the tables above, we need to merge the form, click on the interface above the menu! Options merge cells can be merged successfully. 3, the mouse will be placed in the capital letters of the logo, you can see the downward black arrow, click the mouse to select the columns can be adjusted. 4, in the form of data entry, you can adjust the size of the font, thickness, shape, as needed. 5, the original form is a dotted line, the preview and print does not show the form line, we can click on the box line option, the form will be solid, so that the form in the preview and printing. So that the form in the preview and print when you can display the form line. 6, as shown in the figure pull down the form will appear after a small logo, the logo next to the small triangle point open can have different options, such as copying the cell or fill in a sequence of ways, etc., you can choose according to the need to do so through the above steps can be made a good and simple form. How to use WPS form to create a table first of all, enter the wps interface, click on the toolbar "Insert". In the menu bar click on "Form", in the following you will have three ways to make a form. Choose one method to draw the rows and columns you want to make. After the table is made, click on the table, you will find that the toolbar has been added to the two special tools for the table. In the table properties in the table tool, you can set the width and height of the rows and columns of the table. After the width and height are set, it is necessary to beautify, in the table style toolbar there are several forms of underline, click to set. If these background is not interested in, you can also set up their own beautiful background, back to the form toolbar, in the form of form properties in the form of the lower right side of a border and background settings, enter, you can choose your favorite color of your form of the border of the background of the design can be set up throughout the form, you can set up the cell. So you set up a good-looking form, enter the text can be. wps form how to do, there are tutorials, first of all, enter the wps interface, in the toolbar click "Insert". In the menu bar click on "form", in the following you will have three ways to make form. Choose one method to draw the rows and columns you want to make. After the table is made, click on the table, you will find that the toolbar has been added to the two special tools for the table. In the table properties in the table tool, you can set the width and height of the rows and columns of the table. After the width and height are set, it is necessary to beautify, in the table style toolbar there are several forms of underline, click to set. If these background is not interested in, you can also set up their own beautiful background, back to the form toolbar, in the form of form properties in the form of the lower right side of a border and background settings, enter, you can choose your favorite color of your form of the border of the background of the design can be set up for the entire form, you can set up the cell. This way you set up a good-looking form, enter the text and you're done. I hope it can help you! How to use WPS Forms to create a table Materials / Tools: wps20161, click a cell, selected border is green, you can enter text or numbers inside 2, if you need to merge cells, first press and hold down the left mouse button do not let go for dragging, select the area of the cells to be merged to let go of the left mouse button 3, and then put the mouse in the selected area on the right-click, select the "Set cell formatting" 4, and then click on the top of the "Alignment" tab 5, click on the "merge cells" before the small square, so that the square hit the "√" 6, and finally click "OK" on the merger of cells excel how to create a form excel window is originally a form, enter data in the cell (including numbers, text, time and date, etc.), so that even if the establishment of the a form, just such a form print out no form line, to have a form line needs to be set up, the method is: select the form area, such as "five rows and three columns" or "twenty rows and ten columns" and so on, click on the "Format "?ú Cells" to open the "Cell Format" dialog box, select the "Border" tab, according to the need to set the border format, such as thickness, color, etc., point border line (inside the border, outside the border or other borders, above all have), and then "OK" window in the form of a line becomes dark or color, print out a complete form. Of course, according to the content, you can also adjust the cell size, font, alignment and so on. How to make tables in excel 1. Create a new Excel file. 2. Draw a good draft on the sketchpad, the need for data on the form style and the number of columns and rows to determine. For example, I need to create a table of five rows and six columns, the top is the title line. 3. In the new Excel, use the mouse to select the number of rows and columns of the form you need, and then click the right button, "Set Cell Format" - " Border", in the "Preset" in the "outer border", "internal" border, as needed. 4. If the title, you can cancel the outer border, merge the horizontal or vertical form. Method is also the first to select the need to set up the form (the first line), and then right-click on the "set cell formatting" - "Alignment", and then select the "5. According to the title length, width adjustment of the title line. Such as my title is "XXXXXXX company table" title longer, the title line will be widened, set the "automatic line feed" method as shown above, and then according to the needs of the left and right indentation, adjust the center, and then set the font size and so on. Look at the chart before the adjustment: according to the font adjustment table, as shown: 6. Other spaces after filling in the content, the same according to the content of the adjustment can be. 7. If you need to print, you have to set the page. We look at this table is horizontal, so choose "File" - "Page Setup", select "Horizontal", and then print a preview. If the requirements of the center of the print but the form is in the upper left corner of the page, adjust the margins. Adjust the position of the print can be. 8. If you need to insert this table into the word document for other uses, it is also very simple. First of all, just made the Excel table saved as a file name "equipment table" to the desktop. The page will be set to landscape, otherwise the table will not display the full. Word document needs to be inserted in the place, click the mouse, and then select the top "Insert" - - "Object" - "by the file to create", and then find just saved "equipment table", insert, OK, and then inserted into Word. The effect is as follows: the following results of a class as an example: this is a result, the items have been entered into the form, but there is no header, the results of the various achievements have not been calculated, if printed, the page is not set. First, now first to this table to join the table header: first insert a line for the table header. Right-click on the "name" column on the left "1", (see below) in the dialog box that appears we click "Insert", so there is more than one line on the top, (the same way you can) insert multiple lines. (The same right-click on the left most representative of the number of rows can be deleted from the corresponding line). You can add a header in this row (see Figure 2). Input the contents of the table header, to first "merge cells", how to merge cells? in the "name" column on the top of a top cell, hold down the left mouse button to the right and pull, and has been pulled to the "Notes" column on the top of a cell so far, (after the selected cell is light blue) in order to neatly. Then click on the upper toolbar on the "Merge Cells button" in Figure (2): so we can enter the header content, by adjusting the font size, font selection to reach the satisfaction. As shown:.