Excel automatically changes columns

1.Laptop.

Excel** automatic column change method:

1.Create a new Excel with Excel 2010, click on File and select Options. <>

2.Check the directions in Advanced.

3.Change the direction to the right.

4.Enter the custom content in the ** cell.

5.Press Enter.

Observe the box position change (see the black box in the figure).

Merge Excel bot can automatically merge excel in the same folder by custom number of rows. Merge.

After selected, you can't click the mouse, you can't press the arrow keys, and you need to use the following shortcut keys to adjust the cells:

Enter: Move the cell down.

Shift+Enter: Move the cell up.

tab: Move the cell to the right.

shift+tab: Move the cell to the left.

The image below is a demo animation, which needs to be clicked to view:

When cell A1 enters 1, g1=b1-c1, the cell value is obtained, and the cell value is copied downwards to get the value of g200.

When cell A1 enters 2, g1=d1-b1, the cell value is obtained, and the value of g200 is obtained by copying down.

When cell A1 enters 3, g1=d1+f1, to get the cell value, copy down, get the value of g200.

When cell A1 enters 4, g1=b1+c1, the cell value is obtained, and the value of g200 is obtained by copying downward.

When A1 enters 1000, and so on...

When cell A1 enters 1, the value obtained by G1:G200 is copied and pasted into column H.

When cell A1 enters 2, put the value obtained by G1:G200 into column I by copying and pasting it selectively.

When cell A1 enters 3, the value obtained by G1:G200 is copied and pasted into column J.

When cell A1 enters 4, the value obtained by G1:G200 is copied and pasted into column J.

When cell A1 enters 5, the value obtained by G1:G200 is copied and pasted into column L.

Q: Is there a way to do it automatically: when cell A1 enters 1, the pure value of column h is obtained.

When cell A1 enters 2, the pure value of column I is obtained.

When cell A1 enters 3, the pure value of column J is obtained.

When cell A1 enters 4, the pure value of column K is obtained.

That is, every time the value in cell A1 increases by 1, the result is moved backward by one column, and automatically moved back, and the resulting value in each column must be a pure value.

It's better to use ordinary formulas or array formulas, instead of VBA, how to use formulas to achieve this? Thank you!!