Dictating Cell Navigation Order

Bret

New Member
Joined
Oct 9, 2002
Messages
1
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!
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
You could unlock the cells you want information entered in and protect the sheet, you can then tab between the unlocked cells
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,203,232
Messages
6,054,274
Members
444,713
Latest member
SAK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top