1, input various data;
2. After inputting the data, set the font (if there is no requirement, you don't need to set it);
3. Adjust the column width or row height of the table. 4. If there are other requirements, set other data.
2. First, enter the data. Suppose you want to enter the sales performance table of employees of a real estate company in the first quarter of 20 14. Just enter the original data into Excel first. As shown below.
Third, after inputting data, you can set the font size. Generally speaking, in a more formal table, most of the titles are bold. So choose the title, and then choose bold under the font. Then set the font size of the title. As shown in the figure.
Fourth, general column titles can be directly bold. You don't need to set it to a font different from the content. As shown in the figure, the font of the salesperson can be bold.
Fifth, then select all the contents and set the alignment. Generally choose the center, if necessary, you can choose the appropriate format according to your needs! As shown in the figure.
6. Because the content looks a little crowded, set the row height and column width as needed, copy the content first, then move the mouse into the content, and drag one of the rows down with the mouse, and you will see the height number as shown in the figure. Keep pulling until you are satisfied.
Seven, or directly select the content that needs to modify the line height, click the right mouse button, and the line height as shown in the figure will appear, and then directly enter the number in the dialog box. The same is true for column width setting, which is also the above two methods.
Eight, in fact, there is no grid line in the performance table, but a table should be added. Therefore, the next step is to find the grid lines under the view options and cancel the check.
Nine, add the table is a box below the starting font, click it will appear as shown in the figure. Select all borders? Do it. Then I finished drawing this performance table.
Note: When selecting content, such as setting the line height, you should select the whole line. The so-called whole line, that is, even the number of the left line label should be selected. Otherwise, right-clicking does not set the row height.