Dictating Cell Navigation Order

[Bret]

Hello all,
I'm a relative newbie to Excel. There may be an easy, obvious solution to this question, but I can't find it.

I set up a form for an Auto Repair shop to use as in invoicing form. They just fill in the correct cells with the appropriate information and print it.
Question: Is there a way to set the order so that you can navigate through the cells in a preset pattern? It would be nice to just bang the ENTER key and have it go from cell to cell in a specified order.

Thanks in advance!

 

[Paul B]

You could unlock the cells you want information entered in and protect the sheet, you can then tab between the unlocked cells

 

[bolo]

Not exactly what you want but this could help.
Select your whole sheet go to format,cells and then protection and check the locked box.
now select all the cells that require input. repeat but this time make sure the locked check box is clear.
Then go to tools and protect the worksheet.
The tab key then navigates through all the cells that haave not been locked.


Doh! too slow!
This message was edited by bolo on 2002-10-10 22:04