You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.

Spread the loveMicrosoft Excel is a popular spreadsheet software that is used for a wide range of purposes, including data analysis, financial modeling, and accounting. One of the core features of ...

If you want to print an Excel spreadsheet but don't want to include rows that have a cell value of zero, you must filter the spreadsheet. Filtered rows will be skipped when you print your document.