selected cells

J

Juco

I have a spreadsheet whereby a number of the cells are protected and only
those that require info to be inserted can the user insert data. Is it
possible to list the order (cell no) that the cursor jumps after they press
enter?

thanks
Juco
 
R

Ragdyer

Where you wish to enter data into unprotected cells in a protected WB, you
should hit <Tab> in order for the focus to move to the next unprotected
cell.

If, on the other hand, you wish to follow an *exact* preferred order of data
input, you could try the procedure in this old post:

http://tinyurl.com/39vzv
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data entry problems in excel 1
How do I select specific cells to be my tab stops? 4
Quick way for monthly linking of Excel sheets 0
Formula results display only after pressing Enter key 1
jumps cells 2
Formatting in a Protected Spreadsheet 6
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
saving options along with spreadsheet 1

Top