Auto Navigate Cells
 

Hi,

Is it possible to make excel spreadsheet automatically snap to cells or
jump around the spreadsheet when enter (return key) is pressed rather
than just going down one cell?

I would like the user to have to only enter data then return key and it
goes to next cell somewhere else and then enter data and return key
etc.

TIA,

Aaron.

Auto Navigate Cells
 

Aaron
Highlight the cells that you want the user to use, go to
Format/cells/protection and uncheck the box.
Then protect the sheet and tell the user to use TAB to move around the sheet.
It will then only go to the unprotected cells.

HTH
Michael M

"Aaron" wrote:

Hi,

Is it possible to make excel spreadsheet automatically snap to cells or
jump around the spreadsheet when enter (return key) is pressed rather
than just going down one cell?

I would like the user to have to only enter data then return key and it
goes to next cell somewhere else and then enter data and return key
etc.

TIA,

Aaron.

Auto Navigate Cells
 

Hi,

There are two possibilities :

1. Select all your input cells in one go in order to Insert Name Define
....
Once you have created a range, you will be able to Tab from one cell to
the other ...

2. Slightly more sophisticated, the same approach but encapsulated into
an event macro
private worksheetchange ...

HTH
Carim

Auto Navigate Cells
 

Hi Aaron

Not sure whether this will be of help.
You could select your range of cells holding down Ctrl as you click from
cell to cell, then give this selection a name e.g. Data in the Name box
(above row 1 and to the left of column A) and press Enter.

If you then type Data in the Name box, the cells will be highlit, and
your cursor will be at the last cell in the range.
Hitting Enter will take it to the first cell, where you can enter a
value and each successive press of Enter will take you to the next cell
in the range. Press down arrow or right arrow to escape from the
sequence.

--
Regards

Roger Govier


"Aaron" wrote in message
ups.com...
Hi,

Is it possible to make excel spreadsheet automatically snap to cells
or
jump around the spreadsheet when enter (return key) is pressed rather
than just going down one cell?

I would like the user to have to only enter data then return key and
it
goes to next cell somewhere else and then enter data and return key
etc.

TIA,

Aaron.

Auto Navigate Cells
 

Thank you everyone that helped with this I have got a solution out all
of your ideas that is working well for me now.

Cheers,

Aaron.
Roger Govier wrote:
Hi Aaron

Not sure whether this will be of help.
You could select your range of cells holding down Ctrl as you click from
cell to cell, then give this selection a name e.g. Data in the Name box
(above row 1 and to the left of column A) and press Enter.

If you then type Data in the Name box, the cells will be highlit, and
your cursor will be at the last cell in the range.
Hitting Enter will take it to the first cell, where you can enter a
value and each successive press of Enter will take you to the next cell
in the range. Press down arrow or right arrow to escape from the
sequence.

--
Regards

Roger Govier


"Aaron" wrote in message
ups.com...
Hi,

Is it possible to make excel spreadsheet automatically snap to cells
or
jump around the spreadsheet when enter (return key) is pressed rather
than just going down one cell?

I would like the user to have to only enter data then return key and
it
goes to next cell somewhere else and then enter data and return key
etc.

TIA,

Aaron.