Excel Entry Tips

In the use of Excel, the first need to input data, to make their own data recorded skillfully, recorded province, or need to master a lot of practical skills.

Input skills

Quickly fill in the same content

When multiple cells are selected, enter the characters, and then press Ctrl+enter to fill in the same characters in each cell that you select.

Quickly copy cells on

Select the following cell and press CTRL + ' (' single quotation mark for Latin text ') to quickly copy the contents of the previous cell.

Quickly enter system date

Press CTRL + Key to quickly enter the system date.

Text Digital Input Tips

In general, any number you enter in a cell is placed in the right alignment format, and Excel treats it as a number. If you want to enter a text format number, in addition to the cell in advance of the text format, as long as the number of more than one ' (single quotation mark) can be.

Score Input Tips

If you set the Excel cell to the fractional format beforehand, you can enter the fraction data such as 2/3.5/6. In addition, you can enter fractions in the general cell in the format of "0 space fractions", such as "0-2/3" (-a space) to display "2/3", and data processing by 15-digit numeric precision. However, this method does not enter a denominator of more than 99, or the input result is displayed as 0.

Quick switch technique of input method

Click data → effectivity, open the Input Mode tab in the Data Validation dialog box, select Open in the Mode Drop-down list, and then click OK at the end. The input method that you have set will be activated automatically as long as you select a cell that is valid for an input method.

Quick Tips for adding information

If you want to add information to the end of the cell data, you can select the cell and press the F2 key. The cursor will appear at the end of the data, enter the data and return.

Quick tips for inserting parameters

If you know the name of the function you are using, but you do not know its parameters to use, you can enter the formula bar equals and function names, and then press CTRL + A key, Excel automatically open the parameter Input dialog box, you can directly enter the parameters.

Quick editing Tips

If you want to edit the contents of an Excel cell, just double-click the location you want to edit, and the cursor will be inserted into the double-click Point of the cross cursor. You can quickly change the name of a label by double-clicking the tab of the Excel worksheet and entering the text directly.

Repeat action

To apply the format of a cell (or range) (font, font size, row height, column width, and so on) to multiple locations, you can select the cell (or range) above. Then double-click the Format Painter button, drag the mouse over several areas that you want to format, and then click Format Painter again to finish the operation.

If you want to draw multiple lines or ellipses, you can double-click the related button on the Excel Drawing toolbar, and then you can repeat the drawing. To cancel this feature when you double-click a button, simply click the button or press the ESC key.

Easy implementation of multiple lines of text input

Excel default cell Enter a line of text, a simple way to achieve multiple lines of text input is when you want to start a new row in a cell, just press Alt+enter to enter two or more lines of text in one cell.

Read it and proofread it for you.

Excel adds a text To speech feature that reads the data in a cell. You can open the text to Speech toolbar by pasting the Word file into the worksheet and clicking Tools, Speech, and commands. Select the area on the worksheet that you want to read aloud, and click the Read aloud button on the toolbar by rows or by column. When you click the Speak Cells button, Excel reads all the contents of the range of the menu's cells. Chinese characters and numbers are more accurate to read aloud, English words can only be broken down into letters, but for general proofreading is enough.

Data Synchronization Scrolling

How do you need

To observe the two columns of data that are farther away, you can do this by moving the mouse over the splitter box at the right end of the horizontal scroll bar, then dragging horizontally after the bidirectional cursor, which splits the current worksheet into the left two panes with a vertical bar. Drag the scroll bar to make the data you want to see visible, and then synchronize the two columns of data in the usual way. If you need to cancel the vertical split line, just double-click it with the mouse.

Decimal or 0 Input tips

To have Excel automatically populate the decimal or fixed number of 0 of fixed digits, you can set the following settings: Click Options on the Tools menu, open the Edit tab, and select the Automatically set decimal point option. If you need to automatically populate the decimal point, enter (or select) the number of digits to the right of the decimal point (for example, "2") in the digits box. If you need to automatically fill in zero after the number you enter, enter the number of minus and zero (such as "3") in the number of digits box.

If the previous setting is used, then 2.68 is displayed after entering 268. If the latter setting is used, then 268000 is displayed after entering 268.

Wrapping within a range of cells

Converts a long line into a paragraph and wraps the line within the specified range. For example: The A10 content is very long, want to display it in column A to C column, step is: Select the area a10:c12 (select A10 first), select "Content rearrangement" of "fill" on "Edit" menu, A10 content will distribute in A10:C12 area. This method is particularly suitable for annotations in tables.

Special symbols for multiple entries

Sometimes you have to type a few special symbols (such as) on a single worksheet more than once. Very troublesome, the input speed has a greater impact, you can use a one-time replacement method to solve: First, the user can enter the location of special symbols to use a letter to replace (such as *), please note that this letter can not be the form of the letter required, When the form is finished, open the Edit menu, and then enter the Replace character "*" in the Find what box in the Replace dialog box, in the Replace Value box, type, cancel the selection of cell matching, and then press the Replace button to replace the If the user can determine that all "*" in the worksheet is in place of "", you can also press the Replace All button and replace it all at once.

Adjust decimal points automatically

If a user has a large number of less than 1 digits to be entered into the worksheet, then please enter the following settings before the entry, the input speed will be increased by several times: select tools → options, click the Edit tab, select the "Automatically set the decimal point" check box, in the "number of digits" In the edit box, fine-tune the number of digits that you want to appear after the decimal point, and the user can enter them according to their needs, and click OK.

Open a text file directly

Select file → open, and then click the file Type Drop-down list, select text file, so you can get the data you want from the text file you have open.

Import Text File contents

Using an open method to import data has a disadvantage that once the data has entered Excel, it cannot be synchronized with the text file. At this point, you can use the import text file to operate: Select data → "Get External Data" → "Import text file", you can also get the data in the text file, while importing data, Excel will use it as an external data range. This allows users to refresh or periodically refresh data when they need it.

Format a number as a text type

In Excel, select the text format in the number label by selecting the cell that contains the value, and select the cell item in the Format menu, and click OK. With this technique, you can also format a number as a postal code, phone number, social security number, and so on, by selecting a special item in the selection box under the number label and determining the appropriate type.

Quickly enter a number with a decimal point

When you need to enter a large number of digits with a decimal point, such as 0.0987, you typically

is to enter the "0", ".", "0", "9", "8", "7" a total of 5 digits, not only error prone, but also very low efficiency.

In fact, you can use Excel to set the function of the decimal point automatically, so as to improve the speed of input. 3, open the tools → options → edit tab, first check the "Automatically set the decimal point" checkbox, and then set the number of digits to the right of the decimal point in the number edit box. In this way, with a decimal point number, you only need to enter the number directly, but you can omit the decimal point input, it will be automatically positioned after the ENTER key!

Enter duplicate data

Excel supports automatic fill, to enter duplicate data, you can enter one cell after another, and then automatically fill the line. However, if the cells that you want to enter duplicate data are discrete, or if you want to enter data that is weeks, months, days, and so on, the AutoFill feature will not complete the task. In fact, you can select all the cells you want to enter duplicate data, and then enter the data, and finally hold down the CTRL key and then hit enter.

Quick positioning in Excel

What if the Excel worksheet has 33333 columns and if the data in column No. 23456 needs to be modified? It takes a long time to drag the scroll bar with the mouse or the page key on the keyboard. At this time, try if you hold down the SHIFT key and drag the scroll bar, will you be able to find it soon?

Automatically convert uppercase amounts

Many users in the production of financial statements, often need to represent the number of figures as uppercase, if only rely on simple input, it will be very troublesome, in fact, you can set the format of cells to achieve. Right-click the cell that you want to display with an uppercase amount, and choose Format Cells from the shortcut menu that pops up. In the pop-up dialog box, select the Number tab, and in the Category list, select Custom, and in the Type box, enter "[dbnum2]0" Hundred 0 "0" "0" Corner "" ", and then select this type.

Fast enter numbers in front with 0 in Excel

If you directly enter a number with 0 in front of the cell, such as "001", then the cell appears "1", and the preceding 0 is discarded. The general solution is to first select all cells that need to be entered with 0 digits in front. Right-click on any selected cell, select Format cells, click the Number tab in the pop-up dialog box, and then select text in the Category box. But this operation is undoubtedly more troublesome, the simplest way is: in the input data, first put a single quotation mark, and then enter the front with 0 of the number, the preceding 0 will not be thrown away. For example, to enter "001", type "001" in the cell.

Fast Input Score

Enter "0 3/4" in the cell (note: A space in the middle) is displayed as a fraction (3/4), whereas a date (March 4) is displayed.

Another magical ' number. '

In the input of 11 digits and the above number (such as ID card number), in front of the number plus an English state "'", that is, the normal display, on the contrary, the scientific count method display. At this point, the cell format is text, and its numeric value can only be sorted and cannot be used for function evaluation.

Auto-correction Method input Special text

Select tools → AutoCorrect, open the AutoCorrect dialog box, insert "CT" under "Replace", insert "Computer application" (without quotes) under Replace with, and press the "OK" button. " Once you enter the CT and subsequent text in the cell (or press the ENTER key), the system automatically corrects it to "computer application."

Small Tips

★ The AutoCorrect entries that are defined in Excel are also available in other applications in the Office family, such as word.

★ If you do need to enter text CT, you can

First enter the CT0 and the following text, and then delete a 0.

Find substitution method for fast input symbols

Sometimes you have to enter the same text in more than one cell, especially if you want to enter some special symbols (such as ※) more than once, and you can use the "Replace" method to do this: first enter a substituted letter (such as x) in the cell where you want to enter the symbols. Note: cannot be the same as the letter required in the form), after the completion of the form, with edit → replace (or press ctrl+h directly), open the Replace dialog box, enter the substituted letter "X" in the box under Find what, and enter "※" in the box under "Replace Value" to " Cell Match "∨" is removed (otherwise it cannot be replaced), and then the Replace button is replaced with a single one (if the letter x is really needed in the table, this can be done to meet this requirement.) Note: The mouse is best selected in front of the cell that you want to replace or in the cell above, preferably the A1 cell. Or press the Replace All button to complete all replacements at once (all of the X in this table is replaced and the mouse can be selected in any cell).

Small Tips

While holding down the Ctrl key, select multiple discontinuous cells (or ranges) with the left mouse button, enter text (such as ※), and then press the "Ctrl+enter" key, or you can enter the text into the selected cells.

Fast data entry using a select list

If the text you want to enter is already entered in front of the same column, and there are no empty cells in the column, right click on the cell below, choose the Select list option, the text entered below the Drop-down menu form, with the left arrow to select the text you need, you can quickly enter the selected cells.

Format Definition Method

Sometimes you need to add units (such as "meta") to the input values, and a small amount of input can be entered directly, and a large number of input from one to one is too slow. To automatically add units to a number by using the custom cell formatting method: For example, select the cells you want to add units to, select format → cells, open the Format Cells dialog box, click the Number tab, select the Custom option under category, and then type Enter "#平方米" in the box below, press "OK" button, and then enter the value in the cell above (numeric only!) , the unit (square meter) is automatically appended to the value.

Skillfully use the symbol bar in Excel

Select "View" → "toolbar" → "Symbol bar", and then you can select the appropriate symbol from it.

Clever use of character mapping table

Select "Start" → "program" → "Attachment" → "System Tools" → "Character Map", click the Special Symbol button, and then through the previous, Next button to pull out various symbols, select, click the Select button, and then click the Copy button, you can paste into Excel.