AUTO POPULATE VALUES IN EXCEL

Suppose the above picture is worksheet sheet2, the cell where the salary scale is located is A1, and the cell corresponding to the salary is A2

Another A 800

b1000c1500

D2000 assumes that this cell range (A1:B4) is in sheet 1

First, implement the drop-down list shown in the figure above in sheet2 through data validity.

1. First name the cell range (A1:B4) of sheet sheet1:"Insert a Name definition"and give the area a name aaa

2. Position the mouse in the a1 cell of sheet2 of the worksheet, write aaa in "Data Validity Set Validity Condition Allow to Select Sequence", and then press OK to achieve the drop-down list shown in the figure above.

Also, enter the formula vlookup(A1,Sheet1!) in cell A2 of the corresponding salarya1:b4,2,0) can be realized in a1 to choose a, the corresponding salary is 800 and other functions.

First find out the law of the values, and then use the function to write the formula, write one, and then copy it down.

Let's assume that the pay scale is A1, B1 and enter the formula.

if(a1="","",vlookup(a1,,2,))

1. Open Excel and select the "Rows and Columns" option box of the "Start" option.

2. Click on the "Fill" option in this box.

3. After that, select the "Sequence" option.

4. If you need to fill in "rows", select "rows" in the sequence dialog box and select "autofill".

5. Click OK to generate data, and the value can be automatically filled.

So how to set up autofill in excel, the operation method is as follows.

1. First of all, in the computer, open the excel** you want and click on the file in the upper left corner.

3. Click on Advanced Options, and you can find the "Cut, Copy & Paste" option bar.

4. Then select the Paste option button when pasting content, and click OK to turn on the excel autofill function.

5. At this time, select one or several consecutive cells containing numbers, and then drag down the autofill option in the lower right corner of the cell, and then select the filling method.

1. First set the cell drag-and-drop function and display the paste option button, generally excel is the default, to introduce the steps and methods of setting, as shown in the figure, open the tool options, and select the "options" button.

3. At this time, you can use the autofill function, as shown in the figure, first select the cells to be sorted, place the mouse in the lower right corner, at this time the mouse becomes a small black cross, drag the mouse to pull down.

4. At this time, you will see that the pulled down grid will automatically display the numbers in a certain order, drag to the desired position, and then in the lower right corner, an autofill option will appear.

5. Click on the autofill option, a dialog box option will appear, there are different collations, select the required rules, and the sorting will be autofilled.

Open the document for which you want to set up the autofill feature. Select and right-click the cell for which you want to set autofill. Click on the "Format Cells" option in the right-click menu.

Click the "Align" setting item on the settings screen. Select "Shrink Font Fill" in the "Alignment" settings screen. Finally, click the "OK" button at the bottom of the interface, detailed steps:

1. Open the document that needs to be set up with the autofill function.

2. Select and right-click the cell that needs to be set for autofill.

3. Click the "Format Cells" option in the right-click menu.

4. Click the "Alignment" setting item on the settings interface.

5. Check "Shrink Font Fill" in the "Alignment" setting interface.

6. Finally, click the "OK" button at the bottom of the interface.

Fill - sequence, you can set it inside, look at it,

No setup required.

Select a grid, move the cursor to the lower right corner, change to "+" and press the left button to fill it in four directions: up, down, left and right. It is to fill the data, formulas, etc. in the grid into other grids. If you enter a regular data, select the box to fill it in according to the regularity.

For example, if you type , you can fill in .and other odd numbers.

1. Click on the first cell, which is a series of cells that start with numbers. This is done by having each cell display its corresponding row number.

2. Enter =row(A1) in the cell (if it is an A1 cell). If it is not cell A1, please enter the corresponding number. For example, if you're typing in cell B5, enter =row(b5).

3. Press the Enter key. Then the cell will display the travel number. If you enter =row(a1), the cell will show 1. If you enter =row(b5), the cell will show 5.

4. Select the cell that contains the first number in the sequence.

5. Hover the cursor of the mouse over the lower right corner of the selected cell, there is a square dot here, it is called the autofill handle. When the mouse cursor is directly above the fill handle, it becomes a cross. If you don't see the fill handles, go to File Options Advanced and check the option to enable drag and drop for fill handles and cells.

6. Drag and drop the fill handle to the last cell of the number sequence. The cells in this column will then display their corresponding row numbers.

If you want to realize the auto-fill function of excel, you need to set up the folder drag and drop function and display paste option button, generally excel is the default, and the method of realizing excel** autofill is as follows:

1. First open the tool options and select the "Options" button to tell you nonsense.

2. Open the selection button, enter the dialog box, select the options in the second column, and then tick the box in front of "Cell Drag and Drop Function" and "Show Paste Option Button".

3. At this time, you can use the autofill function, first select the cells to be sorted, place the mouse in the lower right corner, at this time the mouse becomes a small black crosshair, drag the mouse to pull down.

4. At this time, you will see that the drawn grid will automatically display the numbers in a certain order, drag it to the desired position, then in the lower right corner, an autofill option will appear, click on the autofill option, and a dialog box option will appear, there are different sorting rules, select the required rules, and the conversation will automatically be filled in and sorted.

This clear sale is the result or is old.

formula, a2=if(b1="Household shirt ascended to the Lord",countif($b$1:b1,b1),"

Insert a column to the right of column A: new column B.

Enter the formula in b2:

if(a2=""b1,a2)

Then populate the formula down to get the data you want. Slippery Crack.

Additional steps: Select the whole column B, copy it, and then right-click in the source grid of cell B1 --- paste as value, so that the formula in column B is gone, only the value is kept.

At this point, you can delete column A and the new column B will become column A.

Material Tools: Excel2003

1. Open the excel2003 version, and then enter the data on the ant high with a smile, we are in B2, B3, B4 respectively in B2, B3, B4, and then enter the constant 2 to be multiplied in C2, what we get is: let the original data B column multiply the constant 2 after the result is displayed in D column.

2. At this time, we enter the formula =b2*$c$2 in the second row of column d, and then press the enter key on the keyboard.

3. After entering, then we can see that the first data 1 in column b multiplied by constant 2 to get the result is 2, which is displayed in column d, and then go back to select cell d2, and use the mouse to place the black dot in the lower right corner of the cell, when it is a black cross, pull the mouse down.

4. At this time, the result of multiplying the original column by the constant is automatically filled.

Excel automatically fills in numbers in ascending order mainly into the following steps:

1. Fill in the initial data in the required columns, in order to facilitate the system to distinguish the data step size, fill in at least two hidden data, as shown in the following figure:

2. Select the filling data, move the mouse to the lower right corner of the checkbox, when the mouse arrow is converted into the fill handle pattern, left-click the mouse and drag it down, as shown in the following figure:

Yes, here's how to do it:

1. As shown below, here open Excel and Word at the same time, and copy some cells in Excel.

2. Enter the word window and click "Paste" - "Paste Special" under the "Start Menu".

3. After opening the paste window special, click "Paste Link", select "Format Text (RTF)" on the right, and click "OK".

4. At this time, you can paste the selected cells in Excel into Word in the form of links.

5. The effect is as follows, when the score of 95 points in the score column is changed to 15 points, the number of people below 60 points in the score range on the right becomes 3 people, and the number of people below 60 points in word becomes 3 people simultaneously.