The drop down menu item in Excel can not be selected with a number

You can do without the drop-down list at all.

Right-click on the worksheet name View and enter the following:

private sub worksheet_change(byval target as range)

on error resume next

strarray = array("1 Excellent", "2 good", "Intermediate", "4 passes", "5. Fail", "6 poor", "7 exceptions", "Extremely poor", "oh,my god!")

if = 3 then 'If the set cell is in the third column, the rows and columns can be changed here.

If you set rows, the column in this command is changed to row= strarray(-1).

end if

end sub

It seems that it can't.

If you don't want to use a mouse.

Press the letter after the alt+menu item (or alt+f to open the file menu) and the submenu will be as close to that letter.

Excel data cell drop-down numbers are very common operations, the specific operations are as follows:

1. Select a data and pull down from it to make an incremental series. Place the mouse in the lower right corner of the cell and click the drop-down when it becomes a cross.

2. See that the default sequence format is the same number.

3. Click on the pattern containing the cross in the lower right corner of the sequence number, and select the second filling sequence in the menu.

4. The data of the sequence becomes incremental.

Another way is to fill in two or more data at the beginning, and then select two data in the empty talk at the same time to pull down, so that the result will also become data incremental.

Or there is an easier way to select a data pull-down increment, which is to hold down the Ctrl key while pulling down, and it will become an increment sequence.

There is also if excel**.

If you input less Chinese case data, you can use the built-in function of the input method to quickly complete the input, and use the Sogou input method.

For example, enter "V+Numbers and Socks Touch" in the cell, and select the format you want to display in the drop-down options.

1. Open the excel file, and click the mouse in the first cell filled with consecutive numbers. Which one.

2. Then enter the same number in the first three consecutive cells, such as 88.

3. After Sun Zai, drag Li Kaixun's mouse to select three cells, and the mouse cursor changes to a black cross.

4. Drag the mouse down to the cell you want to fill, and you can finish filling.

5. As shown in the figure below, the filling effect of the same number has been completed.

6. If you need to set the format of the padded value, you can set it by clicking the small icon in the lower right corner.

There are many ways on how to quickly pull down numbers in excel, and the results are different with different methods. The main means are:

1. There are 0 numbers in front of it (such as: serial number, number, etc.), this kind of number should be set to text format in advance, if starting from 001, the mouse is placed at the border junction in the lower right corner, and the hollow plus sign becomes a solid black small plus sign when holding down the left button to pull down, it will form a ......continuous numbers;

2. There is no 0 number in front, if this kind of number is to be continuous, it is necessary to enter such as 1 and 2 in the first two squares, select two boxes with the mouse and put them at the junction of the border in the lower right corner, and hold down the left button when the hollow plus sign becomes a solid black small plus sign, and it will form a ......continuous numbers;

3. Fixed numbers, as long as you enter the number in the first box (such as 500), use the method of the first point to pull down;

4. Discontinuous numbers (such as ), you should enter such as 1 and 3 in the first two squares, select the two boxes with the mouse and put them at the junction of the border in the lower right corner, and hold down the left button when the hollow plus sign becomes a solid black small plus sign, and the ...... will be formedDiscontinuous numbers.

5. There are many more, figure it out for yourself.

Fill in first, one or two numbers, select all, and then place the mouse in the lower right corner of the selected area, at this time the mouse will be displayed as a small black cross, and then press the left mouse button and drag!

1. Pure number does not increment drop-down and place the mouse in the lower right corner of the cell. Where the circle is located, when the word "ten" appears, pull down the mouse; 2. The pure digital tolerance is 1 increment, and the operation is the same as step 1. The only difference is that when the cursor changes to the word [ten], first hold down the CTRL key, and then pull down the mouse; 3. The pure digital tolerance is not 1 increment.

For example, if you want to pull down ...As shown in the image, enter in the first column first. Then select the two cells illustrated, place the mouse in the lower right corner of the selected cell, and pull down the mouse. 4. If you want to copy the drop-down, on the basis of the previous step, when the cursor appears in the lower right corner of the selected cell, press and hold the CTRL key and then pull down, the result is as shown in the figure; 5. Chinese characters, numbers mixed drop-down; The mixed drop-down case for kanji and numbers is the opposite of the drop-down case for pure kanji.

For example, if you want to pull down "Zhang 1", "Zhang 2", and "Zhang 3", when the cursor selects the cell, the word "ten" appears, and when you start to pull down, you can not hold down the CTRL key; 6. If you only want to pull down a series of [Zhang 1] out, you need to hold down the CTRL key when you start pulling down the above are about Excel's 6 ways to pull serial numbers, I hope the above information can help you!

Select the first cell that already has a number, place the mouse at the border junction in the lower right corner, and click the left button to pull down when the hollow plus sign becomes a solid black small plus sign

That's because it's not doing it right.

2. I found that after pulling down, all of them were 1, and they did not become 1234 and other first mu, so click the icon on the right side of the last ear pei cell.

3. In the pop-up box, you find that the current format is to copy cells, so all of them are the number 1, then select the "Fill Sequence" option and click it.

4. You will find that column 1 becomes 1234....15 such an ordered number.

1. Comprehensive functions: it can process almost all kinds of data. Easy to use: menus, windows, dialogs, toolbars.

2. Rich data processing functions, rich charting functions: automatic creation of various statistical charts, rich automation functions: automatic correction, automatic sorting, automatic filtering, etc.

3. Fast and accurate computing, convenient data exchange ability, and new web tools.

1. Open the excel file and click the mouse in the first cell filled with consecutive numbers.

2. Then enter the same number in the first three consecutive Sun Chidan cells, such as 88.

3. Then drag the mouse to select these three cells, and the cursor of the mouse will change to a black cross.

4. Drag down to disturb the mouse to the cell you need to fill, and you can complete the filling.

5. It is the filling effect of the same number completed.

6. If you need to set the format of the filled value, you can click the small icon in the lower right corner to set it.

Open Excel.

Please click Enter a description.

We test ** with a drop-down option.

Please click Enter a description.

Enter the first option value.

Please click Enter a description.

Enter a second option value.

Please click Enter a description.

Enter the third option value and click on the fourth row blank.

Please click Enter a description.

Press Ctrl+ and we can see that a drop-down menu will be automatically generated for all the values we have just entered.

Please click Enter a description.

Click on the data drop-down and we can see that the data has been selected automatically.

Please click Enter a description.

What number do you want to pull down?

1. If it is the same number: enter the range of cells you want to fill in the name box - press Enter - then enter the number you want to fill in the column - press Ctrl+Enter.

2. If you want to fill the sequence: first enter your first sequence number in the first cell - menu bar - start - section - fill - series - the "Sequence" dialog box appears - the sequence is generated in: click "row (or column)" - step value:

1 (or whatever value you want to increment) – Stop Value: Enter the number you want to get to - OK.

Use the fill handle function to pull down the numbers.

Excel version reference: 2010

1. Select cell A1, enter 1, and press enter.

2. Select the A1 unit and scroll down to A10

3. Click the "Tian" font icon in A10 (select according to your needs), select the filling sequence 4, and view the effect (1-10 has been generated).

Place the mouse in the bottom right corner of the cell. Where the circle is located, when the word "ten" appears, pull down the mouse;

2. The pure digital tolerance is 1 increment, and the operation is the same as step 1. The only difference is that when the cursor changes to the word [ten], first hold down the CTRL key, and then pull down the mouse;

Then select the two cells illustrated, place the mouse in the lower right corner of the selected cell, and pull down the mouse. 4. If you want to copy the drop-down, on the basis of the previous step, when the cursor appears in the lower right corner of the selected cell, press and hold the CTRL key and then pull down, the result is as shown in the figure; 5. Chinese characters, numbers mixed drop-down;

The mixed drop-down case for kanji and numbers is the opposite of the drop-down case for pure kanji. For example, if you want to pull down "Zhang 1", "Zhang 2", and "Zhang 3", when the cursor selects the cell, the word "ten" appears, and when you start to pull down, you can not hold down the CTRL key;

6. If you only want to pull down a series of [Zhang 1] out, you need to hold down the CTRL key when you start pulling down the above are about Excel's 6 ways to pull serial numbers, I hope the above information can help you!

1.Enter 12Select the cell, place the mouse in the lower right corner, the cross symbol appears, and pull down 3Click the pop-up button to select the pop-up sequence in the interface.

You can use a stupid way to add a serial number to 2000 rows of data, and then insert a column to add the same mark to the 1500 records that are filtered out, and then sort them according to this column, so that the 1500 records screened out can be connected together to add a serial number to them. Finally, if you want to revert to the original order, you can sort by the first serial number.