Log In
Register
Home
New Member
April 15, 2022
Offline
I have scanner to scan those values and i set my cursor to move right
What i want:
I want that when i scan first value in row E column1 cursor jumps to row F column1 the. Row G column 1 but after that i want that cursor doesn't go to Row E column 1 it should move to again Row E column2 then Row F column 2 then Row G column3
And then so on .....
Please anybody can help me on that
See Answer
November 8, 2013
Offline
Hi Mandeep,
First I think you are referring to rows as columns and to columns as rows (row E, row F are columns not rows), that makes it difficult to understand.
In order to make the cursor jump to the next cell you want, select ALL CELLS that should receive values from scanner, right Click>Format Cells, then in protection tab you have to clear the Locked checkbox.
Then, from Review tab in ribbon, Protect the sheet with the option to Select Only UNLOCKED cells. This way, the cursor will move only in the ranges you have unlocked, in the order set by the excel option to "Move Right" or "Move Down"
Answers Post
1 Guest(s)
