Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have an excel worksheet (Check request form), that I would like to use as a
fill in form for other uses to complete. I want them to fill in only certain cells and the rest of the worksheet be locked. |
#2
![]() |
|||
|
|||
![]()
Terri, select all the cells that you want others to be able to fill in and
then format, cells, protection, uncheck locked, then got to tools, protection, protect sheet, now only the cells you had selected cnan be filled in. You can also tab between the unprotected cells -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Terri" wrote in message ... I have an excel worksheet (Check request form), that I would like to use as a fill in form for other uses to complete. I want them to fill in only certain cells and the rest of the worksheet be locked. |
#3
![]() |
|||
|
|||
![]()
Paul B wrote:
|| Terri, select all the cells that you want others to be able to fill || in and then format, cells, protection, uncheck locked, then got to || tools, protection, protect sheet, now only the cells you had || selected cnan be filled in. You can also tab between the unprotected || cells -- || Paul B || Always backup your data before trying something new || Please post any response to the newsgroups so others can benefit || from it Feedback on answers is always appreciated! || Using Excel 2002 & 2003 || || "Terri" wrote in message || ... ||| I have an excel worksheet (Check request form), that I would like ||| to use as a fill in form for other uses to complete. I want them ||| to fill in only certain cells and the rest of the worksheet be ||| locked. And then add a password to the protection, so some bright spark can't UNprotect it! -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I increase file limitations to convert a file to Excel? | Excel Discussion (Misc queries) | |||
how do i convert an excel file from a mac to a file on excel for . | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |