Learn how to protect your Workbook, Worksheet, and specific Ranges from getting manipulated by outsiders. Quit 'telling' these coworker to not 'touch' your work... simply apply Excel's built in protection features.
Text27:56 Ask each user for a password when loading file content. Simply navigate to 'File' (on the ribbon), 'Save As', 'Computer'. The 'Save As' dialog box will appear. At the bottom of the window, click the 'Tools' button/down arrow, click 'General Options', and then fill in the 'General Options' dialog box.
02:26 Protect your workbook from being changed. Get protected from some of the following: adding/deleting, hiding, and moving worksheets.
03:30 Protect worksheet content. There are many individual functions that you can protect your worksheet against. To view all of them, navigate to the 'Review' tab on the ribbon.
06:35 Protect a specific range of cells within your worksheet. This is perfect for 'calculation cells'. Your coworker won't screw up all your hard work again!
08:40 Collaborating with others on one workbook? Track their changes and only accept the changes that you agree with. Simply select the range of cells you'd like to tracked, and click the 'Track Changes' button within the review tab on the ribbon. Select 'Highlight Changes', and read the options in the dialog box.
VideoGIF
Integrity-Outlines-ALL.xlsx