A Drop of Excel - 08 | Restrict and Protect in Excel

Опубликовано: 09 Апрель 2020
на канале: Excel Rush

841

In terms of applying restriction and protection, let us learn the most essentials that you must know in Excel,
How to make a dropdown in Excel
How to allow data entry only in certain cells in Excel
How to allow only numbers greater than 0 or 1000 or any number
How to lock Excel file with a password

Example file link
https://drive.google.com/file/d/1paOr...

\ Previous video:    • A Drop of Excel - 07 | How to work wi...
/ Understanding of the data being used in the examples:    • A Drop of Excel | Understanding the d...

Related Videos/Posts
How to restrict duplicate data entry in a column in Excel --    • How to Restrict duplicate data entry ...
18 Most Useful Excel shortcuts --    • 18 Most Useful Excel Shortcuts