QuickBooks HelpQuickBooksHelpIntuit

Show only active rows and columns on reports in QuickBooks Online

SOLVEDby QuickBooks585Updated January 25, 2024

To keep things less cluttered when you're looking at your reports, you can hide rows and columns with no activity or a total amount of zero. This ability is only available for some reports.

Note: This does not apply to payroll reports.

To show only active rows and columns:

  1. At the top of the report, select the Show non-zero or active only dropdown. If you don't see Show non-zero or active only, it isn't an option for that report.
  2. Choose which rows or columns to show:
    • Active: Hide empty rows and columns.
    • All: Show all rows or columns.
    • Non-zero: Hide rows and columns with a total of zero.
  3. Select Run report.

That's it. Now you know how to show only active rows and columns in your reports.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online LedgerQuickBooks Online PlusQuickBooks Online Simple StartQuickBooks Online Solopreneur

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this