Create Fill In Template in Excel?

G

Gretchen

Attempting to create template, in Excel 2003, that will tab from one desired
fill in field to the next. Have tried protecting the sheet, but then can't
either lock or unlock the cells desired. Have saved as a template, deleted
extra unused sheets, but just am not getting it!!! HELP!!!
 
G

Gord Dibben

The locking/unlocking of cells must be done before sheet protection is applied.

By default all cells on a sheet are locked when sheet protection is enabled.

Select the cells you want to Tab to and Format>Cells>Protection. De-select
"locked".

Tools>Protection>Protect Sheet.


Gord Dibben MS Excel MVP
 

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

Excel Template 13
Can I get excel to automatically fill color to all unlocked cells? 3
How do I create a form in Excel that I can send to be filled out? 2
Excel Excel macro to insert template sheet to all files in directory 0
How to creat a template 1
Series fill only copying and fill series greyed out 1
Compatibility error when saving file. 4
Create a form in Excel 1

Top