Stealth Excel Formulas - Hide, Lock, and Protect

preview_player
Показать описание

This short video shows how to hide a formula as well as protect it. Specifically:
- hide a formula from the formula bar
- hide a formula from the cell
- how to protect a worksheet
- how to prevent a user from changing a formula cell

Chapters in this video:
00:00 - Introduction
00:13 - Exercise 1
00:58 - click-start
01:03 - Exercise 2
02:00 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

Рекомендации по теме
Комментарии
Автор

I really like your videos, no waste of time, directly on the subject presented and clearly explained. Thank you very much.

micheltremblay
Автор

IDK if I'll ever use this, but I'm glad I know how these functions go together.

michaeliverson
Автор

Can we get a link to the workbook for this video?

jedidiahbeeman
Автор

How to protect the entire sheet and allow users to edit only a specific section of the shared spreadsheet? Please reply

Prafful
visit shbcf.ru