Automatically enter data in Excel worksheet cells

To quickly enter data, you can have Microsoft Office Excel automatically duplicate data, or automatically populate data.

　　Automatically repeat items that have been entered in the column

If the first few characters you type in a cell match an existing item in the column, Excel automatically enters the remaining characters. However, Excel can only automatically complete items that contain a combination of text or text and numbers. Items that contain only numbers, dates, or times cannot be automatically completed.

Do one of the following:

• To accept the suggested item, press Enter. Items that are automatically completed take the case of an existing item entirely.

• If you do not want to use the automatically supplied characters, continue typing.

• If you want to delete automatically supplied characters, press Backspace.

Comments

• Turn off this option if you do not want to automatically complete the entry you typed.

How to turn automatic completion of cell values on or off

1. Click the Microsoft Office button

, and then click Excel Options.

2, click Advanced, and then under Edit options, clear or select the Enable AutoComplete for cell values check box to turn off or turn on the automatic filling function for cell values.

· Excel completes input only when the insertion point is at the end of the current cell's contents.

· Excel can enter data into the active cell, which is the selected cell, based on the activity cell: the active cell. You can have only one active cell at a time. The border around the active cell is bold. Provides a list of possible AutoComplete entries. Items that are duplicated on one line cannot be automatically completed.

　　Populating data with fill handles

You can use the Fill command to populate the worksheet cells with the data. You can also have Excel automatically continue a combination of numbers, numbers, and text, a sequence of dates, or periods, based on the pattern you establish. However, to quickly populate several types of data series, you can select a cell and drag the fill handle fill handle: The small black square in the lower-right corner of the selected area. When you point to the fill handle with the mouse, the mouse pointer changes to a black cross. )

。

By default, the fill handle is displayed, but you can hide it.

How to hide or show a fill handle

1. Click the Microsoft Office button

, and then click Excel Options.

2, click Advanced, and then under Edit options, clear or select the Enable fill handle and cell drag-and-drop check box to hide or show the fill handle.

3. To avoid replacing existing data while dragging the fill handle, make sure that the warn before overwriting cell contents check box is selected. Clear this check box if you do not want to receive messages about overwriting cells that are not blank.

After you drag the fill handle, the Auto Fill Options button appears

So you can choose how to populate the selection. For example, you can choose to fill only cell formatting by clicking Fill Format only, or you can choose to fill only the contents of the cell by clicking Fill without formatting.

If you don't want the AutoFill options button to appear each time you drag the fill handle, you can turn it off.

How to turn auto fill options on or off

1. Click the Microsoft Office button

, and then click Excel Options.

2, click Advanced, and then under Cut, copy, and paste, clear the Show Paste Options button check box.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join