1. Open a blank EXCEL file on the computer. If you need to set the table file to landscape orientation, click the page layout above and select the paper orientation as landscape orientation.
2. Enter the company roster in the first cell, then select other cells on the page, click the merged cell above and center it.
3. Enter the required information such as serial number, name, position, ID number and home address in the following cells. Click on the Tian Zige logo above and select all the border buttons.
4. Select the required line, right-click, select the line height button, and enter the required height in the pop-up line height dialog box.
5. Then enter the relevant data information in the cell and click the Save button to complete the basic production of the spreadsheet.
Method 2
Beginners need word software to make spreadsheets on the computer. There is a horizontal menu bar at the top of the document. Click Insert, and then click Table.
1. Download and install word software, start the software, and then create a new blank document.
2. There is a horizontal menu bar at the top of the document. Click Insert with the mouse, and then click Table below.
3, that is, a panel pops up. There are small squares here. Place the mouse on the grid, and the grid is yellow, indicating that it is selected. Then, pull horizontally, then pull vertically, and then click with the mouse. Then, create a blank table.
4. Cells in a table can be called cells. Click the mouse on a cell to position the cursor in the cell. Then, enter the text you want.
5. Where the cursor is, click and wipe it to the left of the text, and then select the text. Then, click the Layout tab, click Alignment below, and then click Horizontal Center.
Precautions:
1, when using word, you will care about the basic format of word. Generally speaking, the basic format of word is Song Ti, No.5.
2. When using word document, don't press ENTER and SPACEBAR at will.
3. Be good at editing documents with shortcut keys in word.
4. When using word documents, be sure to save them regularly.
5. When using word documents, if you have any questions you don't understand, you must consult professionals in time.