Excel Usage Tips

In the work of the spreadsheet to deal with the data will be more rapid, convenient, and in a variety of spreadsheet processing software, Excel with its powerful, convenient operation, won the favor of the majority of users. Although Excel is very simple to use, but really good Excel users are not many, many people have been stuck in the level of data entry, this article will introduce you to some of the most used skills, mastering these skills will greatly improve your productivity.

⒈ quickly define workbook formats

First select the scope of the workbook you want to define a format for, click Style on the Format menu, open the Style dialog box, and then select the appropriate style type from the Style Name list box, and choose whether to use the style's number, font, alignment, border, pattern, protection, and so on, click OK to close the Style dialog box, the format of the Excel workbook changes according to the style specified by the user, which satisfies the user's requirement for a quick, large-format definition.

⒉ Quick Copy Formula

Replication is an operation that applies formulas to other cells, most commonly in the following ways:

One is the drag system copy. To do this, select the cell that holds the formula, and move the hollow cross cursor to the lower-right corner of the cell. When the cursor changes to a small solid cross, hold down the left mouse button while dragging along the column (when calculating the row) or row (when calculating the column) to complete the copy and calculation of the formula at the end of the data. The speed of the formula copy can be adjusted by the small solid cross cursor distance from the virtual frame: small solid cross cursor is farther away from the virtual frame, the faster the copy, conversely, the slower the replication.

You can also enter replication. This method completes the copy of the formula as soon as the formula input ends. How to: Select all cells that need to use the formula, enter the formula in the method described above, and then hold down the CTRL key while you press ENTER, and the formula is copied to all the selected cells.

You can also paste selectively. To do this, select the cell that holds the formula, and click the Copy button in the Excel toolbar. Then select the cell that you want to use the formula for, right-click in the selection, and select Paste Selective in the shortcut menu. When you open the Paste Selective dialog box and click OK, the formula is copied to the selected cell.

⒊ quick display of formulas in cells

If the data in a worksheet is mostly generated by a formula, if you want to quickly know the form of a formula in each cell, you can do this: with the left mouse button click the Tools menu, choose Options command, the Options dialog box appears, click the View tab, and then you can set the formula item under the window options bar to work. Click the OK button. The formula in each cell is displayed. If you want to restore the display of formula results, then set the formula item under the window options bar to fail.

⒋ Quick Delete blank line

Sometimes in order to delete blank lines in an Excel workbook, you might find the blank line one by one and then delete it, which is inconvenient. You can use the AutoFilter feature to simply implement it. First insert a new row in the table (Panyan), then select all rows in the table, select Filter on the Data menu, and then select the AutoFilter command. In the item section of each column, select Blank from the Drop-down list. When all the data is selected, select Delete rows from the Edit menu, and then press OK. All the empty rows will be deleted. Insert a blank line to avoid deleting the first row of data.

⒌ Automatic Switching Input method

When you use Excel 2000 to edit a file, there are usually Chinese characters and letters and numbers on a worksheet, so for different cells, you need to constantly switch between the English and Chinese input, which not only reduces the editing efficiency, but also makes you annoying. Here, the author introduces a method that enables you to automatically switch the input method to different types of cells in Excel 2000.

Create or open a range of cells that you want to enter Chinese characters, click Effectivity on the Data menu, select the Input Mode tab, select Open in the Mode Drop-down list box, and click OK.

Select the range of cells that you want to enter letters or numbers, click Effectivity on the Data menu, select the Input Mode tab, and in the Mode Drop-down list box, select Close (English mode) and click OK.

After that, when the insertion point is in a different cell, Excel 2000 can automatically switch between Chinese and English input methods according to our settings. That is, when the insertion point is in the cell we set to enter Chinese characters, the system automatically switches to the Chinese input state, and when the insertion point is set to enter a number or letter cell, the system automatically closes the Chinese input method.

⒍ Adjust decimal point automatically

If you have a large number of less than 1 to enter into the Excel worksheet, if the entry before the following settings, will make your input speed multiplied.

On the Tools menu, click Options, and then click the Edit tab, select the Automatically set decimal point check box, and type the number of digits you want to appear to the right of the decimal point in the bits spinner edit box. Here, we type "2" to click "OK" button.

When you're done, if you type "4" in a cell on the worksheet, the number of that cell automatically changes to "0.04" after you press ENTER. It's more convenient! At this point, if you type "8888" in the cell, the number of the cell automatically changes to "88.88" after you finish typing.

⒎ with "Memory input"

Sometimes we need to enter the same number in one column of a worksheet, and it will help you a lot if you use the "AutoComplete" type. such as in the title of the statistical table to be imported multiple "assistant engineer", when the first input, the second time to enter the text, only need to enter the box in the "Help" word, Excel2000 will use the word "help" and this column of all the contents of the match, if the "Help" word and the column has been entered in accordance with the entry, Then Excel2000 will be the remaining "assistant engineer" four words automatically fill in.

Set AutoComplete as follows: Select the Options command in Tools and select the Edit tab in the Options dialog box, and then select the AutoComplete option in the.

⒏ fast input with "AutoCorrect" mode

You can use this feature to not only correct the accidental clerical errors in your input, but also to define a phrase that is often used, and AutoCorrect will change it to the defined text when you enter the phrase. You can also define your own AutoCorrect entries: First, select the AutoCorrect command in Tools. Then, type the phrase "enthusiasts" in the Replace box in the Pop-up AutoCorrect dialog box, and in the Replace with box, type the content you want to replace "reader of computer enthusiasts"; Finally, click OK to exit. As soon as you enter the "Lovers", the entire name will be lost in the table.

⒐ quickly enter data with a drop-down list

If you want to reduce the amount of manual input, you can use the Drop-down table to achieve this. To create a Drop-down list method: First, select the cell or range of cells that you want to display the Drop-down list; Next, select the Validation command on the menu Data menu, select sequence from the Valid Data dialog box, and click the small icon to the right of the source bar to open a new valid Data Small dialog box; Enter the data you want in the Drop-down list in the dialog box, separating the items and items with commas, such as "engineer, UNIDO engineer, technician," and then enter. Note In the dialog box, select the Provide drop-down arrows check box, and then click OK.