Microsoft Excel - Hide Formulas

Learn how to hide cell formulas so unauthorized viewers can't see what you're thinking.

File Download Link:

[Paladin]

I watch A LOT of excel videos and have only recently discovered you. Excellent content, great pace, nicely presented, and useful titles that actually relate to how “I” look for things. Surprised you don’t have more subscribers but I’m confident that will change 👍

[excel_along_the_way]

Hi, when you protect sheet and you take of tick on "Select locked cells" then they can't place their curser on any locked cells and that way nobody can see your formulas and they forced to select only unlocked cells.

[Devin_Downing]

Interesting, well done; however, is there a workaround for when a user uses a macro to insert and delete rows in the table? I have a table and two macros, "Insert Table Row" and "Delete Table Row"; however, when I select 'lock' & 'hidden' and then protect the sheet, the macro(s) bugs out. Within the Protect Sheet Tab, I even selected Insert Row & Delete Row, and that didn't help as it kept bugging out.... Curious if there's a workaround you may be aware of? Might make for another good video? I basically need to keep specific columns hidden and non-editable by the users but allow functionality for inserting and deleting rows within the table via two distinct macro buttons.

[dulebarbul]

How can we change the font size in the formula bar to be different (bigger) from the font size in the cells as we saw in your video?