The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Excel Print Titles is an important feature for multipage reports where the columns and rows of related data spill over to other pages. Learn to use this feature effectively.

You use Microsoft Excel 's built-in function to freeze specific rows and columns (often row or column headers), so when you’re scrolling through, these cells remain stationary on the page.

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.