Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

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.

You can do that without using formulas by viewing cell counts in the status bar at the bottom of the main window.

Microsoft Excel 2010 does not plot hidden rows or columns, so you need to hide the empty rows or columns. Strangely, in Excel 2010, unhiding the data is easier than hiding it.