Simplify payday and set payroll to run automatically on QuickBooks.

Green Circle Icon with Stylized White Letters
QuickBooksHelpIntuit

Show only active rows and columns on reports in QuickBooks Online

by Intuit • Image Alt Text 13 •
Image Alt Text Updated 5/26/2026 04:35

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.
Some of your reports will look different depending on whether they're in the classic view or new enhanced experience. Learn more about the new enhanced experience.

To show only active rows and columns:

  • In the report, select General options.

  • Select the Number format ▼ dropdown, then select the Don't show zero amounts checkbox.

    • Active: Hide empty rows and columns.

    • All: Show all rows or columns.

    • Non-zero: Hide rows and columns with a total of zero.

Note: The report refreshes when a different option is selected. You can also select Refresh icon. Refresh report.

QuickBooks Online AdvancedQuickBooks Online PlusQuickBooks Online Simple StartQuickBooks Online EssentialsQuickBooks SolopreneurQuickBooks LedgerQuickBooks Online FreeQuickBooks Online LiteQuickBooks Solopreneur Plus

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

Sign In / Sign Up

Related Articles