Excel table Making Tutorial

This tutorial is an introduction to Excel tutorial that details the process of making a general Excel table. Before making a form, you need to think about the general layout and style of the table in your mind so that the actual operation can be completed smoothly.

1. Create a new Excel file.

2. Draw a good draft on the papyrus, you will need the data table style and number of columns and rows to determine. For example I need to build a five-element six-column table, the top is the header row.

3. In new Excel, select the number of table rows you want with your mouse, and then right-click, format cells-borders, and select the outline, inner border, as needed in presets.

4. Add borders as needed. If it's a heading, you can remove the outer border and merge the horizontal or vertical tables. The method also selects the table that you want to set (the first row), then right click on Format cell-align, and then select merge cells.

5. Adjust the header line according to the length and width of the title. If my title is "xxxxxx Company table" topic is relatively long, the title line to widen, set the "line Wrap" method as above, and then indent as necessary, adjust the center, and then set the font size.

Look at the chart before the adjustment:

Adjust the table according to the font, as shown in figure:

6. After filling in the other blanks, the same adjustment can be done according to the content.

7. If you need to print, you will set the page. Our table is horizontal, so select "File"--"Page Setup", select "Landscape", and print a preview. If you want center printing but the table is in the upper-left corner of the page, adjust the margins. After adjusting the position, you can print.

8. If you need to insert this table into a Word document for other uses, it is also simple. First save the Excel table you just made as a filename, device table, to the desktop. The page is set to landscape, otherwise the table will not be fully displayed. In the Word document where you need to insert, click the mouse, then select "Insert"---"Object"--"Create by File", then locate the device table that you just saved, insert, OK, and then insert it into Word. The effect chart is as follows:

Form making