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.

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

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

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.