Move cursor to...on exiting cell

[Guest]

Excel 2003;
Can I move to a preselected non-adjacent cell when exiting a cell.
I have a spread sheet laid out like a form and need to jump to the next data
entry cell on the sheet. Can I do this or do I need to create an actual data
entry form.
This is a sheet I turn in at he start of a new job. I don't need to save it
or make a data base. I just need to move thru it quickly.

 

[Guest]

Hi,

1. You can do this by turning on Tools, Protection, Protect Sheet and
unchecking Select Locked Cells. or
2. You can select all the cells you want to move between and then press
Enter or Tab to advance through them.

 

[Guest]

Thanks Shane,
I knew I could lock or unlock cells and then protect the sheet to enter data
only in unlocked cell. I usually shaded these cells for entry. I didn't
realise when I tab or press enter the cursor would only move into unlocked
cells.
Thanks, I'll try it.
furnaceman

 

[Gord Dibben]

If your cells are in a left to right and top to bottom order, see Shane's
answer.

If in a random order.................

You can use a named range to "jump" through in any order you design.

Select SECOND cell then CTRL + click on each succeeding cell in sequence, ending
up with the cell you want to start at.

Insert>Name Define........give your range a name and OK.

In namebox select the name and the cells will be highlighted in the order you
want.

Just type and hit ENTER key to go to next cell.

Note: there are limitations on the number of cells in a range.

See Bob Phillips' site for more help on this.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is a VBA method if you choose. Post back for that.


Gord Dibben MS Excel MVP