How do I limit data entry columns?

  • Thread starter Thread starter Mark 123
  • Start date Start date
M

Mark 123

I have 3 columns of data I want to record from a whole pile of bank
statements:

Date, Amount, Code

So, it's a lot of data-entry.

How do make the cursor cycle the 3 columns as I am inputing data so that I
can just use the ENTER key after entering in these numbers?

TIA
 
Hi Mark,

One way:

Below your column headers, select a 3-column block of (say) 100 rows -
change to suit, preferably slightly greater than your anticipated data entry
requirement.

Set cursor movement on enter to Down or Right (Tools | Edit | Direction)
according to the desired data entry direction.
 
Thanks. Works well until I use the arrow keys to navigate within the box
then it looses it.

Thanks though. I am setting it up for a data entry person and don't know
whether they'll be able to re-select the box.
 
Hi Mark,
Thanks. Works well until I use the arrow keys to navigate within the box
then it looses it.
Click to expand...

Try,

Right-click worksheet tab
F4 to display the sheet's Properties Window
In the Scroll Area box enter: $A$1:$C$100
Alt-F11 to return to Excel
As before, set the cursor direction

Now the data entry person cannot leave the designated columns.

To regain access to the rest of the sheet, repeat the above steps and delete
the Scroll Box entry.
 
Try also menu Data > Form while the active cell is in your list.

HTH. Best wishes Harald
 
Back
Top