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

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.

Did you know that you can hide data in individual cells or ranges of cells in Excel without changing your spreadsheet's content or structure? It's surprising that Microsoft Excel doesn't have a ...

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