Wednesday 18 January 2017

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