Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.

Microsoft Excel displays all cell references by default. When you click on a cell, its column and row references are highlighted in the worksheet's column and row headings.

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

Removing hidden metadata information from a Microsoft Excel spreadsheet is not difficult if you follow the steps laid out here.

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.

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.

Nearly every Microsoft Excel workbook I own—especially those I share with others—contains a hidden backend worksheet. It's essentially the engine room of my workbook and helps me keep my ...