Stealth Excel Formulas - Hide, Lock, and Protect
HTML-код
- Опубликовано: 28 июн 2024
- File Download: www.excel-university.com/yt_i...
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
Subscribe here 👉 ruclips.net/user/ExcelUniver... and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
🚀 Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro 👉 excel-university.com/challenge⚡️🕒 Say goodbye to late nights and spreadsheet struggles!
Also, check out these videos with time saving Excel Hacks:
Excel PivotTables for Beginners • Excel PivotTables for ...
Watch VLOOKUP Hacks Playlist here • VLOOKUP Hacks Series
Watch VLOOKUP vs SUMIFS Playlist here • VLOOKUP vs SUMIFS Series
Watch Dynamic Arrays playlist here • Dynamic Arrays Series
Watch Treasure Maps playlist here • Treasure Maps Series
Watch Slow to Fast playlist here • Slow to Fast Series
I really like your videos, no waste of time, directly on the subject presented and clearly explained. Thank you very much.
So glad it's helpful!
IDK if I'll ever use this, but I'm glad I know how these functions go together.
Might come in handy someday!
This is incredibly useful.
Glad to hear it and happy to help!
Can we get a link to the workbook for this video?
How to protect the entire sheet and allow users to edit only a specific section of the shared spreadsheet? Please reply