We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Excel Worksheets

akbiro
akbiro asked
on
Medium Priority
265 Views
Last Modified: 2012-05-11
Attached is an excel worksheet.  Notice the yellow cells.  I want to protect all cells excepting those in yellow.  How do I do it.  I can protect the one yellow column of cells but not the others.
NewSalesWorksheetXtreme.xlsx
Comment
Watch Question

first unprotect all

set format cells->protection->locked for all the cells except for the yellow cells

now protect the worksheet. your need will be done!

thanks,
bala

Author

Commented:
Can't find set format cells...
select all cells

right click

select "Format cells"

select the last tab "protection"

Author

Commented:
Let's try it a different way if you could.

1) protect the entire sheet.
2) unprotect those cells that are yellow.

How do I do that?
to protect cell level, u have to set the option i had mentioned.

select entire sheet.

right click

select "Format cells"

select the last tab "protection"

check in "Protected"

now select the column u want to unprotect

check out "Protected"

now protect the entire worksheet.

this protects those cells that has "Protected" and leaves out those dont have.

Author

Commented:
So there isn't a way to set up something in excel that when I select Protect and Unprotect, it knows to protect any cell that is not yellow.  I have to go thru this routine described above each time I want to protect it.

Author

Commented:
I want to highlight the yellow cells and click on a protect button...that is my specific question.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I figured it out...Just click on one of the top yellow sales.

Then Review>Changes>Protect Sheet>
Click on Select Unlocked Cells

Works like a champ!!

Author

Commented:
THanks again!
cool! it should have been by default on your worksheet. select locked cells & select unlocked cells.

great..

enjoy!!!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.