hi wrblee. select the entire worksheet first by pressing CTRL + A or click on the box on the left of Column A & on top on row 1. press CTRL + 1 to go to Format Cells. go to the tab "Protection". Uncheck the "Locked". press OK.
now select only those you want to lock (i.e. those in yellow. J1:Y5 & T18:Z25). again, CTRL + 1 & go to the tab "Protection". Check back the "Locked".
Now, right-click the Sheet "ENG" & Protect Sheet. only those you did in Step 2 will be locked
Bookmarks