If you want to display the formula in cells instead of calculated results in an Excel spreadsheet, here is how you can do that. It is possible to show the used or applied formula and hide the ...

Creating a list of duplicate values that’s separate from the source data is a bit more difficult. Fortunately, thanks to Excel’s FILTER() dynamic array function, creating a list of duplicate ...

Click OK. This option doesn’t change anything. The zero values still exist — you can see them in the Formula bar. However, Excel won’t display them; thus, this method has no impact.

Spreadsheets can get complicated, and frequently you need to be able to compare two different sets of data that are widely separated on your Mac or PC screen. An easy way to do that is to freeze a ...