This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Although more secure than right-clicking a tab and clicking "Hide," making a worksheet very hidden isn't a fail-safe method to stop people from accessing sensitive data stored in your workbook.

Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.