IF you are not comfortable with creating forms in your document, and yet need to take user inputs you can create a semi-locked range of cells. All you need to do is create a range of cells containing fi xed values and editable values.
In Excel, the cells are locked by default, but the users can still edit their content unless you protect the worksheet as explained below. Carry out the following steps for Excel 2003:
In Excel, the cells are locked by default, but the users can still edit their content unless you protect the worksheet as explained below. Carry out the following steps for Excel 2003:
- Open the workbook to which restriction needs to be applied.
- Next, fill out the details that you want to keep fixed in the cell range of your choice.
- Select the required cell range that can be edited.
- Go to the 'Format | Cells'.
Posts
