| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Fill In Template in Excel?
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!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Fill In Template in Excel?
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 FormatCellsProtection. De-select "locked". ToolsProtectionProtect Sheet. Gord Dibben MS Excel MVP On Tue, 18 Mar 2008 12:07:02 -0700, Gretchen wrote: 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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create an Excel Template? | Excel Discussion (Misc queries) | |||
| How do I create a template to fill in government forms? | Excel Worksheet Functions | |||
| create a fill in template to tab to fill in cells | Excel Discussion (Misc queries) | |||
| How do I fill an Excel template from a file | Excel Worksheet Functions | |||
| How do I create a template in Excel? | New Users to Excel | |||
Hybrid Mode
