Is there a way to protect cells on an Excel spreadsheet while working on the spreadsheet?

 

Yes. For example, in below screenshot I have randomly written ‘Protect’ in three cells assuming those are the ones we want to protect and rest should be open for edit.

Step 1: Press Ctrl+A to select the whole worksheet

Step 2: Click on the small arrow box available in the bottom right corner of the Font section on Home tab to see additional formatting options

Step 3: Now, open Protection tab on the pop-up and un-check ‘Locked’ option

Step 4: Select the cell you want to protect, follow step 2 and 3, to ‘Lock’ the cell

Step 5: Click on Protect Sheet (in Review tab)

Step 6: Set a password

Now, you can work on rest of the Spreadsheet, but the Locked cells will be protected. Unprotect sheet to edit the Locked cells.

Is there a way to protect cells on an Excel spreadsheet while working on the spreadsheet?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s