You can open the EXCEL file on the computer, then enter the required information in the corresponding cells, and then adjust the width and height of the corresponding cells according to the actual situation.
Take the establishment of an employee roster spreadsheet as an example, the specific production method is as follows: 1. Open an EXCEL blank file on the computer. If you need to set the table file horizontally, click the page layout above and select the paper orientation as horizontal. 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.
How to make excel tables? What are the basic steps?
1. First, open excel, set the title of the form as "Training School Consultation Registration Form", then select the title and click "Merge Center Options".
2, then adjust the cell size to the height, put the mouse in the middle of two cells, when the mouse arrow becomes a plus sign with an arrow, you can hold down the mouse and drag it to the appropriate height, and release the mouse.
3. If two items appear in a cell at the same time, you need to add a slash. Enter the name and consultation first, and then click and hold alt+enter to divide the middle two items into upper and lower parts. Then press the space until their positions are separated.
4. Then right-click the cell, select the format cell, and then select the border to select the desired row.
5. Finally, click the mouse in the middle position, a diagonal line appears, and then click OK.
6. In this way, the basic excel table is ready, and the effect is as follows.
How to make a spreadsheet in detail?
First, you need to know what a spreadsheet is. If you don't even know what a spreadsheet is, that's it.
This table only needs to input the lottery number of each issue, and it will automatically generate three indicators: sum, amplitude and span.
Note: The data in some lottery software (such as Ruby) can't be directly imported into Excel, so you must first filter it in Notepad and change the attributes of the data.
The first row, the first column, (A 1) input 200 100 1 (first stage),
The second line, the first column, (A2) Enter the following formula in the formula column above:
=IF((COUNTA(B 1:D3)=3)，A 1+ 1，"")
-note that the last four points are a pair of double quotes in the western language state. This formula indicates that the problem number is automatically generated. As long as you enter three lottery numbers, the next number will be automatically generated.
Column 2-4, (B 1-D 1) Enter the lottery number manually.
In the fifth column (E 1), enter:
=B 1+C 1+D 1 (calculated sum)
In the second row and the sixth column (F 1), enter:
=SUM((ABS(E2-E3))) (calculated amplitude)
In the first row and the sixth column, enter (G 1) in the formula column:
= max (b1:d1)-min (b1:d1) (calculation range)
This is the simplest spreadsheet with five data, namely, issue number, lottery number, sum, amplitude and span.
How to make tables in Excel
1. Right-click in the blank space of the computer desktop, and there will be a new one. Click new, click Microsoft Office Excel 2007 workbook, and then open a new Microsoft Office Excel 2007 workbook.
2. after opening Microsoft Office Excel, select the first 5 rows of cells. If there are multiple items in the required table, please select several rows.
3. After selection, click the heading "Merge in the center" under "Word Wrap", that is, in the center position, merge five cells into one cell. Click "Bottom Border" in the border below the theme font again, and a horizontal line will appear;
4. Select some cells you need, select as many columns as you want, and how much content there is;
5. After selection, click all the border lines in the border, as shown below, and all cells will be filled.
6. After filling the cell, click the coordinates 1 and A, and select them all to increase or widen the cell to the required height and width;
7. Now you can fill in the theme and some items you want to divide, as shown below, taking seafood prices as an example;
How to make a spreadsheet on a mobile phone
Click on the WPS software in your mobile phone or carry it with you. If not, you can download one for later use.
Click the New button. Select the form type to enter the form editing page.
Start editing the table. Keyboard and common tools are in the following menu, which is easier to find and operate. Enter text in the text box, and then click Tab to pop it up in the table.
When the table is finished, click the Save icon in the upper left corner. The following screen will appear on the phone screen. Select a location to save the file.
06, the screen appears as shown. The default saving name of the system is Workbook, which can be modified and saved by itself. After changing the name, click the Save button in the lower right corner.
If you have a network, you can send it directly to others! I hope the landlord will adopt it.
How to make tables and charts by computer
This is a computer book about a specific application. Instead of taking practical work and solving specific problems, let computers really double your work efficiency, make your dreams come true, and let you participate in things that you can only think about but can't do in the past.
Based on the background that people often need to organize data with tables and display data with charts in practical Word, this book introduces in a simple way how to make various text tables, such as ordinary wired tables and various digital tables with complex diagonal headers, such as ordered spreadsheets, filtered display tables, classified summary tables and pivot tables, and how to make charts such as bar charts and pie charts with Excel E L's chart wizard, and gives detailed and effective application examples. Through the study of this book, you will see that it is so clear to organize data in tables and display data in charts.
How to make beautiful Excel tables?
There are many tutorials on how to make beautiful slides online, but there is little beautification of Excel. In fact, Excel is not only a spreadsheet software, its cells are easy to control the style and operation, so it is also suitable to make electronic documents for reading only with Excel. This requires document producers to know some basic skills in order to produce pleasant electronic documents.
The following is my experience in making electronic documents in Excel format to share with you. I hope everyone can make beautiful documents.
1. Select the appropriate display scale.
Chinese fonts generally use Song Ti, and the default state 100% is not good-looking (as shown below). Comparatively speaking, 85% is much more comfortable. 75% is a little small, but when you have a lot of data, or when you make documents with more words, 75% is more suitable.
The proportion of 85% is easy to adjust, just press and hold the Ctrl key to scroll the wheel up once in the default state of 100%. 75% need to manually enter the proportion. Display scale less than 75% will distort the text and should not be used.
In addition, after saving the Excel worksheet, the display scale will also be saved together, which can ensure that readers can see the same effect as you.
2. Selection of background grid lines.
Excel will display gray grid lines by default, which has a great influence on the display effect. As shown in the figure below, whether there are grid lines in the same table feels completely different-there are grid lines, which gives people a psychological hint of "this is a data-based table", while removing grid lines will make the focus fall on the contents of the worksheet and weaken the role of the table.
Therefore, the table-based worksheet can keep the grid lines, while the text-based worksheet is best to remove the grid lines.
You can delete gridlines in tools->; ; Option to remove gridlines from the view tab, but this method depends on the settings of the reader, so it is better to choose another method: select all cells (Ctrl-A) and set a white background.
3. Set the appropriate line width.
The width of the table line will also greatly affect the reader's psychology. Use thick and thin lines. The easiest way is to add a thin line and a thick border (just use the border button in the formatting toolbar twice). It seems rude to shout with thick lines; However, the concept of table can not be completely embodied by thin lines; Not using the sideline will make people feel that your data is not carefully crafted.
In addition, when a large number of small cells gather, the surface line will interfere with the reader's line of sight. At this time, you can try to change the border of the small cell into a dotted line.
4. Use bold appropriately, but not too much.
Needless to say, the title should be bold. For the data in the table, in principle, don't use bold, so as not to pretend to be the owner. However, there are also some special cases. When the data is sparse, it can be set to bold for emphasis.
The use of bold is not suitable for flooding. When most of the books on the screen are in bold, you should consider the readers' feelings.
5. Add a background color to the title cell.
There is no doubt that the color of the bottom line of the cell background color button is naturally used as the cell background (the red box below).
My usual color matching habits are: horizontal header-light blue, vertical header-light green, ordinary cells-white, special cells (such as automatically calculated cells)-light yellow, as shown below. In this way, the function of each cell can be distinguished.
6. Use cell combinations as little as possible.
Cell merging has two disadvantages: first, when new rows are inserted before and after the merged cells, the cells of the new rows will not merge automatically, resulting in inconsistent merging methods of each row; Second, in some cases, data cannot be pasted in the merged cells, which brings unnecessary trouble. Therefore, when making tables to collect data, try not to use the cell combination function.
So what if you want a wider grid? In practical application, I found that many people use cell combinations, in fact, they just want a bigger grid. In fact, dragging the cell title can change the size of the cell. Isn't this function known to many people?
7. The method of marking.
There are two ways to mark cells. One is to right-click a cell to insert a note, and then right-click again to display the edited note. The advantage is easy to use, but the disadvantage is that you can't customize the style. Another way is to draw your own pictures. I like to use rounded rectangles, the background color is light and the border color is the same dark color.