Knowledge Focus: I drag the way excel automatically filled using student number (12), but it is repeated several previously selected contents of a cell, how is this going ah? Student ID type used conventional,
moncler jackets sale, numerical, text, are not automatically filled, the original can only repeat a few of the cell ..
drag my way to excel automatically filled using student number (12), but it is repeated several previously selected contents of a cell, how is this going ah? Student ID type used conventional,
there is a ZG, numerical, text, are not automatically filled, can only repeat the contents of the original number of cells: study number is 309020080001,
moncler jacket, I chose a few cells, but is this after dragging Several repeating cell contents by ctrl useless, with the editing of the sequence of ... ...,
My friend sent me this version is not installed there is no windowsxp2000,
moncler coats, arithmetic sequence, did not get any response after the standard answer
Student ID column type is set to: self- Definition /
that in the type box enter
set the type, the number of cells no longer displayed in the form of scientific count. Student ID can automatically fill (12).
specific method
the answer in at 10:58 on June 9 press the Ctrl key as you drag to try
There are two ways want to be Help: 1. If the 2003 version of the drag, the lower right corner a small box appears, click the drop-down menu appears, select the 2. Selected to enter the over two consecutive school number, you can drag.
Automatic Filling Method:
1. Enter the seed filling, which is the first few lines (column) data.
2. Selected to fill the area.
3. Main Menu - Edit - ...- sequence selected in the type of Arithmetic / p>
abc200708002
not below (figures are equal):
abc200708001
abc200708001
this is not can (no arithmetic relationship):
abc200708001
abc200708002
abc200708004
this still can be (different number than the rest ):
abc200708001
acc200708002
figures too, so I can not fill,
moncler jackets women, and ten less than the median should be no problem, as long as you enter the number in preceded by a single quote 'then. But I tell you one way, you can easily enter the school number 12 is very simple. Point
study should be completed two adjacent numbers to determine the sequence of steps, and then use the fill handle down to copy, can be automatically filled by step. Eg, A1 fill 123456789101, A2 fill 123 456 789 102, select the two cells down the copying,
Knowledge Focus, you can succeed.
enter the student number in the table and then click the input box 309 020 080 001, the mouse over the input box to the bottom right corner you will see a small + mark. After clicking the mouse right click on the mark down the drag,
moncler shop, drag, etc. to find and select the location given by way of filling both sequences.
I think you made an error in the most simple one is that few cells should not be selected, should do so: only the first cell is filled 309 020 080 001 and click on it, the mouse moved to the lower right corner of this cell, but the mouse into a solid cross down, hold down the ctrl drag, if it is not drag text directly by ctrl. Try it
upstairs right, but since the definition should enter 309 020 080 000, so enter 1 in the cell is displayed as 309020080001, 309020080002 input 2 is displayed, select the two cells and then fill down on it.
Another benefit of this set is no need to fill also save time, just enter the number of bits that do not display the full student number, such as 309 020 080 352 number, you can just enter 352.
reasons: the format is text format, you can not fill down. screen.width * 0.35) this.width = screen.width * 0.40
Linear Mode
