In this video, I explain how to protect a worksheet and cells within the worksheet with a password in Microsoft Excel 2016. By default, Excel protects all cells in a worksheet when applying a password. The author must unprotect individual cells if they want the user to be able to change a protected worksheet. I also show how to use the RANDBETWEEN function to create random numbers to use as ID numbers for employees. You must use the copy and paste special (values) command to keep the random numbers from changing each time you open the workbook.
Watch video Excel 2016 Protect a Worksheet online, duration hours minute second in high quality that is uploaded to the channel David Clore 18 February 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 10 times and liked it like visitors.