Excel spreadsheet input Tips for a large number of spelling

In cells in an Excel worksheet, you can use two of the most basic data formats: constants and formulas. Constant refers to the literal, data such as numbers, dates, and times can also include logical and error values, each with its specific format and input method, and to give users a clear understanding of the input data, it is necessary to introduce the methods and techniques for entering various types of data in Excel.

One, input text

The text in an Excel cell includes any combination of Chinese and Western text or letters, as well as numbers, spaces, and non-numeric characters, which can hold a maximum of 32,000 characters in each cell. Although there is no essential difference between entering text in Excel and in other applications, there are some differences, such as our in Word, PowerPoint tables, when you enter text in a cell, press ENTER to indicate the end of a paragraph, The cursor is automatically moved to the beginning of the next paragraph in this cell. When you enter text in a cell in Excel, when you click Enter to end the input of the current cell, the cursor automatically moves to the next cell in the current cell, and if you want to branch in the cell, You must enter a hard return in the cell, that is, press ENTER while holding down the ALT key.

Second, input points

In almost all of the documents, fractional format is usually a slash to the numerator and denominator, the format is "numerator/denominator", in Excel, the date of the input method is also used to distinguish between month and day, such as in the cell input "1/2", press ENTER to display "January 2", To avoid confusing the input score with the date, when we enter a score in a cell, we need to enter "0" (0) before the score to differentiate it, and a space between "0" and the molecule, for example, when we enter 1/2, we should enter "0 1/2". If you enter "8 1/2" in the Cell, "8 1/2" is displayed in the cell, and "8.5" is displayed in the formula bar.

Third, enter negative numbers

When you enter a negative number in a cell, you can enter "-" to identify it before negative numbers, or you can place numbers in () brackets to identify them, such as entering "(88)" In a cell, and clicking the Enter key automatically appears as "-88".

Four, enter decimal

When you enter decimals, users can use the decimal point as usual, and you can use commas to separate thousands and millions, and when you enter numbers with commas, they are not displayed in the formula bar, but only in cells. When you need to enter a large number with fixed decimal digits or digits with fixed digits ending with a "0" string, you can use the following methods: Select the tools, Options command, open the Options dialog box, click the Edit tab, select the Automatically set decimal point check box, and in the number of digits In the spinner, enter or select the number of digits to display to the right of the decimal point, reminding you to add 0 automatically after you enter a larger number. You can specify a negative value as the number of 0 that you want to add, such as adding 3 zeros to the cell after you enter "88", and then "88000", and then entering in the bits spinner- 3, on the other hand, if you want to automatically add 3 decimal places to "0.088" after entering "88", enter "3" in the bits spinner. Also, after you have entered a number with a decimal or ending 0 string, you should clear the Select the Automatically set decimal point check box so that you do not affect the input behind it, or you can bring a decimal point when you enter data if you want to temporarily cancel the option set in automatic decimal.

Five, enter the currency value

Excel supports almost all currency values, such as RMB (￥), Sterling (￡), and so on. After the introduction of the euro, Excel2000 fully supports the display, input and printing of the euro currency symbol. Users can easily enter various currency values in a cell, Excel automatically formats the currency, displays in the cell, and if you want to enter a renminbi symbol, you can hold down the ALT key and then press "0165" on the numeric keypad.