9 Tips for using Excel tables

9 tips for using Excel tables

Create an article--Create a table did you do that?

Ching, first we need to create a form out of nothing. By default, Excel has displayed a single cell, and we can enter the data directly into it. Of course, in addition to the basic input, there are some essential techniques in creating tables.

1. Table Plus Frame line

The cell line that is seen by default, whether it is a guide line, is not printed. To display a table format when you want to print, you need to add it yourself. Select all cells that you want to add a table line to, and then right-click it, select Format cells, or press ctrl+1 directly to bring up the cell Formatting dialog box and switch to borders. The "None", "Outside", "inside" above are the options for the entire table. If you want to further refine the table line, such as just one edge of the table, or you can add diagonal lines in different directions for the cell, you could use the following options. The middle Preview box lets you preview the effect.

2. Inserting and deleting cells

Excel tables are frequently changed, and the most common is the addition or deletion of table rows. Right-click on a cell, select Insert, and in the Open Insert dialog box, you can choose whether to insert a cell or to insert an entire row or column. There is also a quicker way to enter the process, directly click on the top of the "insert" under the Triangle button, select Insert row or column can be. To delete a row or column, click the triangle button under Delete to select it.

3. Quick copy and paste

Sometimes we need to enter 1, 2, 3, 4, 5 ... The same sequence of numbers, if the input is obviously too troublesome. In fact, as long as you enter 1 and 2, and then select the two cells, and then drag their lower right corner of the Green Square (at this time the cursor is 10), you can quickly copy an infinite number of sequential numbers. The default also displays the maximum number that is currently copied to.

4. Enter the ID number and other long figures?

Once you enter the ID card in the cell such a long series of numbers, often automatically converted to scientific notation, it seems very inconvenient. In this case, select the cell (select the column if it is an ID number), and then select Format cell to change the number to text. This will not be automatically converted if you enter a long number.

Retouching--The table is more beautiful and more intuitive

After the Excel table is created, the next step is to make the table look better, make some formatting changes, and generate charts.

5. Modify font and alignment

Excel defaults to number 11th and other lines, if you want to change to the appearance of other fonts, you can right-click the cell you want to modify (or select more than one cell right click), at this time the right menu will automatically display the font, font size options, directly to set changes on it. Of course, you can also select the cell, in the top of the toolbar to make changes, without right click.

When the text content in the cell is more, it involves the alignment of the problem, the same font changes, you can set different alignment. Here is a point to note, the general need to set "auto wrap", so you do not have to worry about too much content to show the problem of incomplete.

6. Use of format brushes

The Format Painter can quickly set the same format. When you select a cell, click the Format brush icon on the left side of the Start tab, and then click on the target cell, and the cell's format is automatically synchronized with the source cell.

7. One-click Quick Chart

The best way to decorate the data is to convert it into a chart. Select the appropriate data, the lower right corner shows a quick analysis of the small icon, click on the icon to expand it, switch to the "chart", select "Column chart" to generate a quick chart. Of course, you can also choose a different chart style.

Statistics--The efficiency of tabular statistics accelerates

The most powerful part of Excel is its computational power, which is not explained by one or two techniques. The following two tips are just a few of the Excel calculations that are often used.

8. Quick summation and average

When we enter a series of data, we sometimes want to quickly know the sum of them, or their average. At this point you just need to select the related cells directly, in the State of Excel below, you can see their sum, average, and count display.

9. Commonly used function one key to handle

More complex calculations require the use of Excel formulas, but what do many people do without understanding these formulas? When you select a cell for which you want to place the formula, click Insert Function on the Formulas tab, and in the Open dialog box, select the desired function, which will have a format description for the function, and a description of how the function is used. For more information, you can click on the "Help for this function" in the lower-left corner to see more details.