Related Posts
Stay safe during the Tropical Storm everyone!
Hey Guys, Likes Please to activate DM
Good lord, how’d he survive that?
Red Bull, please drop it!
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.







Coach
If by "protect & hide" you mean hide & lock only the cells you don't want them to change/see, that's pretty straightforward.
Now, I'll advise against lock & hide things: it is a bad practice - not only is not seeing well (depends on the market, but in general), but also it's VERY easy to remove the password protection.
Nevertheless, assuming you're on a given tab and only want to lock&hide the cells with formulas in that tab:
Step 1:
Select only the cells with the formulas, either by hand or, if they are many: Select all cells -> Home -> find & select -> go to special -> formulas (or Ctrl A + ALT H FD S F)
Step 2:
After selecting the cells you want to lock & hide, hit Ctrl + 1, go to "protection" tab (should be the last one), and mark both Locked and Hidden checkbox (or just one, depending on your needs)
Step 3:
Protect your sheet. Go to Review -> Protect sheet. You can choose what exactly you want to protect, but for your case the first two should be enough (it's the default option). Then, set a password and any user would need to input the password to see/change the cells you selected in Step 1*
That's it. Oh, and "Home", "Review" are tabs in the excel ribbon (in the top).
*Again, as a reminder, it is very easy to break the password protection in excel
Coach
Easiest way is to convert to zip, go to the log file, and remove the password
But in this case it's easier to just Google it
P.s.: Just a friendly reminder that hacking into other's excel are still considered a crime in most countries (#notalawyer)
"5. Protect the spreadsheet
Protecting the spreadsheet enables the "Locked" effect. To protect the spreadsheet, start at the "Review" tab, open the "Changes" tab, select "Protect Sheet" to open the "Protect Sheet" dialog, then create and type a password for the spreadsheet into the specified field. The password allows authorized users to access and edit locked cells. Next, select the actions allowed for users. By default, Excel selects the "Select Locked Cells" and "Select Unlocked Cells" actions when protecting the spreadsheet. These allow all users, including those with the password, to only select unlocked and locked cells.
You can choose the actions users can perform, including editing or adding formatting to unlocked cells, by checking or unchecking the boxes next to each action. Once you've chosen the allowed set of actions, select "OK." Excel will prompt you to "Confirm Password" by typing the same password again. Finish protecting the spreadsheet and locking the cells by selecting "OK." -From Indeed.com
Thank you, I’ve tried that and it locked the entire sheet. I just want to hide & lock the formulas & and have remaining cells for data entry.
Just hide the tab with the formula enter data in another tab then lock it