excel automatically jumps into the next cell

Since Worksheet doesn't support keyboard events, you can only add form implementations. This form is displayed when you run the macro (the form has a textbox1).

Write a keypress event for textbox1 like **if > = 48 and < = 57 then= chr(

end if

This is where the next cell is implemented by itself.

As you mentioned, the numbers are regular (in a sequence of equal differences, step size can be set). For example:

Enter 99999999 in A1 and 88888888 in A2, select these two cells and drag down.

1. Open the excel** that needs to be operated, first open a working qin table.

2. Press the F5 key on the keyboard, and a positioning dialog box will pop up.

3. Enter the name of the cell you want to locate in the "Reference Position" of the dialog box, and click the OK button to locate the specified cell.

4. The following figure is the effect of positioning to G13 cells.

5. The second method: shortcut key Ctrl+G. Press the shortcut key Ctrl+G on your keyboard to open the Locate and Search Rock dialog box.

6. In the same way, enter the name of the cell you want to locate to quickly jump to the specified cell.

The reason is that the scroll lock key is turned on, after the key function is enabled, pressing the arrow key in excel will not jump to the cell, but the page will scroll in the corresponding direction as a whole, and the key can be turned off.

Scroll Lock – Screen scroll lock detection. You can lock the scrollbar. The Scrolllock key is a key found on most keyboards.

It first appeared on the 83 keyboard and the 84 keyboard on the AT interface of IBM's PC XT model, and now it is not only on the 101 keyboard of the PC, but also on the "enhanced" keyboard of the Mac. This key was very useful in the DOS era, helping people to easily scroll through the page. It's not very useful now, and it's only available in Excel.

Solution: 1. First open an excel** and enter a piece of character in the cell, which is longer than the width of the cell and needs to be wrapped.

2. Click the cursor of the mouse at the position where you need to wrap the line, and click here in the middle of "turn" and "to".

3. Then press "Alt+Enter" on the keyboard.

4. You can start to jump to the second line after the word "turn" to show the old in the second line.

Tools Materials: Computer, Excel.

The first step is to turn on the computer, open the software to enter, and open the excel to enter the early grip interface.

The second step is to press the F5 key on the keyboard after entering the interface, and the dialog box will pop up.

Step 3, enter the name of the cell you want to locate in the "Reference Location" of the pop-up dialog box, and click the OK button to locate the specified cell.

The fourth step is to complete the automatic jump to the finger Li sliding cell.

1. Click Close in the upper left and right corners of Excel to close excel first.

2. After closing, double-click again to open this **, at this time, a prompt box will pop up to load macros, click to disable macros.

3. Then click on the icon shown by the red arrow in the upper left corner.

4. Then click on the excel option in the pop-up options to enter.

5. After entering, click on the option of Trust Center.

6. In the settings interface of the credit center, click the settings of the credit center.

7. Then click on the macro settings on the left, switch to the macro settings interface, and remove the option to enable all macros.

Now you need to realize: 1. Click B1 to jump to the A** business page.

2. Click C1 to jump to the B** business page.

3. Click D1 to jump to the C** business page.

Step 3: Select cell C1 and repeat the above operation.

Step 4: Select cell D1 and repeat the above operation.

In this way, after clicking on A1, it will automatically jump to the A1** Quotient Worksheet.

In the name box in the upper left corner, directly enter the name of the target cell.

For example, if you enter C5, the cursor will be directly located in the C5 cell.

Enter the specified cell name in the Name box and press Enter.

In the excel state, press alt+f11

Double-click sheet11 (sheet1) in the upper left corner

I see it on the right"Universal", please pull down the worksheet There is a drop-down list next to the worksheet, select caculate

Add the following**.

private sub worksheet_calculate()if range("b1").value = 2 and range("a1").value = 1 then range("c1").

select

end sub

This is calculated if cell b1=2 and cell a1=1 when it automatically jumps to cell c1.

You press the scroll lock key on your keyboard, press it again, and it's back.

You can control the movement with the up, down, left and right keys when selected.,But you can't control it in this way after you enter the data.。。。

Do you understand???

I don't understand, you can read the excel tutorial yourself.,It's a very simple question.。。。