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 easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.

How to Hide Columns and Rows in Excel Hiding rows and columns in your Excel spreadsheet is straightforward, as expected. To do this, select the column or row you want to hide.