Allow Users to Edit Cells in Excel
Steps:
1. Prepare your table like above
2. Select Range(c2:c9) from the table
3. go to Review menu-> click "Allow user to Edit Ranges"
4. Click to Ok
5. Go to Review menu -> Click "Protect Sheet"
6. Enter Password -> Ok
7. Re Enter password -> Ok
8. Now enter phone numbers in phone column. other cells will be locked and can not able to edit.
No comments:
Post a Comment