
Show only active rows and columns on reports in QuickBooks Online
by Intuit• Updated 2 weeks ago
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.
Some of your reports will look different depending on whether they're in the classic view or ![]() |
To show only active rows and columns:
- In case of Modern view:
- In a report, select
General options.
- If available for your report, under Show non-zero or active
, select Active or Non-zero under Show rows or columns, as per your requirement.
- Under Number format
, select Don't show zero amounts.
Note: The report refreshes when a different option is selected. You can also select the refresh report icon.
- In a report, select
- In case of Classic view:
- If available for your report, select the Show non-zero or active only ▼ dropdown.
- Under Show rows or columns, select Active or Non-zero as per your requirement.
- Select Customise, then select ▼ General to expand it.
- Under Number format, select Except zero amount.
- Select Run report.
Notes:
- Active: Hides empty rows or columns.
- All: Shows all rows or columns.
- Non-zero: Hides rows or columns with a total of zero.
You must sign in to vote.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this