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.

How to Hide Empty Data in Excel Graphs. If you have an Excel spreadsheet that contains empty data, such as empty rows or columns, and plot a graph from the spreadsheet, Excel plots all empty data.

Excel's Auto Outline feature quickly hides detail noise so you can view just a summary of your data.

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