Office Excel 2003 in the use of the time, we may often use Excel 2003 to fill the data function to improve their work efficiency. Filled with features generally divided into two categories: First, a copy of the data; the other one is filling sequence. In this paper, we mainly on their use.

Method I: arithmetic sequence and fill copy

Method is commonly used cell type in the values, such as “1″, and then move the mouse to the lower right corner of the cell, the mouse into a bold “+” sign along the row or column and drag the mouse to a certain cells, release the mouse after the value “1″ copy to other cells. If the left side of the cell is a continuous region, double-click the mouse can also automatically copy the data to the last row of a cell; If you drag the process of holding down the Ctrl key, then arithmetic sequence filled way , such as “2,3,4 … …”;

Method 2: Continuous Copy

In two consecutive cell type “1,2″ after, mouse over the “2″ in the lower right corner, the mouse into a bold “+” sign, the drag the mouse to a cell, and so on will be poor way to fill sequence, such as “3,4,5,6″; If you drag the process of holding down the Ctrl key will be to reproduce the form of value copied to other cells, such as “1,2,1 , 2,1,2 “;

Method three: Use dialog box sequence

Enter values in the unit “1″, select “Edit” → “fill” → “sequence” in the pop-up dialog box can be done more choices. Can choose “sequence generated in the” rows or columns, you can choose the type of filler is the arithmetic or geometric, is a date or auto-fill, you can choose the date of the unit, based on our request to set the step value can be set up scheduled to fill the final size of a value, save a large area of trouble to choose;

Method Four: Right-drag sequence

Sequence dialog box provides more options, but need to select the menu can be implemented, so many times too cumbersome to use. In fact, this feature is also a shortcut. We also enter the cell value, will be moved to the mouse to drag the bottom right corner of the cell, but in the process of dragging the note, press and hold the right mouse button instead. Drag to a specific location right after the release, you can quickly pop-up menu to choose and sequence the same dialog box options. And an increase of whether or not filled with the format option, is not it much more convenient!

Method five: from the definition of sequence

Several methods described above, the main numerical sequence for the filling, then how does the text of the filling sequence, which involves a custom sequence. In Excel 2003, has built a number of text sequences, such as the common weeks, Heavenly Stems and Earthly Branches, such as. We enter “Monday”, the drag the mouse, you can appear “Tuesday, Wednesday …” and so on. This setting provides us with a great convenience, you can always use our name, department, classification methods such as self-defined sequence, enter only need to enter a phrase, drag the mouse can be realized after all the phrase filled. Sequence for custom text, select “Tools” → “Options” → “custom sequence” in the right sequence of the region can enter text, or directly from the worksheet in the selected region.