From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Protecting workbooks

Protecting workbooks - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Protecting workbooks

If this is your workbook, but others are allowed to see it and work with it, you might have some security concerns regarding the structure of the workbook and even the appearance of certain worksheets. In this workbook called Security&Sharing, the first sheet here is called WorksheetProtection. And there are some formulas in column J that relate to a table, it's actually on another worksheet called TaxTable, see at the bottom of the screen. Now, you don't want that table to be disrupted or altered in any way and you rather not even have others see it. So what can we do here? We can hide a sheet by Right-Clicking on TaxTable the second sheet from the right, we can choose Hide, and we no longer see it there. At a later time if we need to get this back we can Right-Click and Unhide. And by the way, if you have more than one unhidden sheets you're going to only bring back one at a time. So, we don't want that visible. Now our formula still works, this still refers to the hidden sheet…

Contents