Excel 2007 Protect Sheet Allow Outline. See Also: Excel Auto Outline and Excel Manual Outline. From the Review tab, choose Protect Sheet.
How to password protect Excel spreadsheets, worksheets or ... (Lilly Harrison)
The second step in the process, protecting the entire worksheet, uses the protect sheet dialog box, which contains a series of options that determine what elements. I've tried checking/unchecking every box in the "Protect Sheet" options, but nothing seems to work. Protect individual sheets and the workbook structure, to prevent the insertion or deletion of sheets in the workbook.
It's important to note that all cells can be edited when the sheet is unprotected.
In the Review tab, choose Allow Users to Edit Ranges.
Unable to edit Excel spreadsheet? Easy ways to enable ...
When protecting an entire sheet, it makes sense to leave these options as is. From the Review tab, choose Protect Sheet. By formatting I mean You can password-protect your Microsoft Excel spreadsheets to prevent unauthorized people from opening or editing them.