Best techniques for making tab-able forms?

Eltis · Apr 22nd, 2002, 05:12 PM

Hi, I have several forms that are hard-copy only that I want to make as digital forms in Excel. Basically, I want to lock down most of the form, leaving only the blanks that they will need to fill out. My main question is:

What is the method for making it so that the user is limited to certain cells to tab through? Basically, the active cell will never be a locked cell.

anno · Apr 22nd, 2002, 06:33 PM

select all the cells you want users to tab to (hold down the ctrl key to select multiple cells) and go to format menu>cells>protection tab and uncheck the 'locked' checkbox. then go to tools menu>protection and protect the sheet as instructed. once you've done that you can use the tab key to move to the required cells.

Eltis · Apr 24th, 2002, 12:00 PM

I was thinking about that too, with alot of creative formatting on the locked cells. I think that will probably work, thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 05:12 PM	#1
Eltis New Member Join Date: Apr 2002 Posts: 21	Hi, I have several forms that are hard-copy only that I want to make as digital forms in Excel. Basically, I want to lock down most of the form, leaving only the blanks that they will need to fill out. My main question is: What is the method for making it so that the user is limited to certain cells to tab through? Basically, the active cell will never be a locked cell.

Apr 22nd, 2002, 06:33 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	select all the cells you want users to tab to (hold down the ctrl key to select multiple cells) and go to format menu>cells>protection tab and uncheck the 'locked' checkbox. then go to tools menu>protection and protect the sheet as instructed. once you've done that you can use the tab key to move to the required cells.

Apr 24th, 2002, 12:00 PM	#3
Eltis New Member Join Date: Apr 2002 Posts: 21	I was thinking about that too, with alot of creative formatting on the locked cells. I think that will probably work, thanks.