---
title: Hide Zeros
description: Hide the Excel report rows that contain only zero balances
---

[Skip to content](https://help.finaticalsoftware.com/en/home/hide-zeros#main-content)

![Finatical Software](https://help.finaticalsoftware.com/hs-fs/hubfs/finatical-software.png?width=400&height=69&name=finatical-software.png)

Open main navigation

Close main navigation

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.finaticalsoftware.com/en/home?hsLang=en)
2. [Documentation](https://help.finaticalsoftware.com/en/home/documentation?hsLang=en)

# Hide Zeros

## Hide the Excel report rows that contain only zero balances

![hide-zeros-80](https://help.finaticalsoftware.com/hs-fs/hubfs/hide-zeros-80.png?width=80&height=80&name=hide-zeros-80.png)

The Hide Zeros feature allows you to hide the Excel rows that contain only zero balances. Simply select the Excel cells that contain the report and click the Hide Zeros button. Flash Reports will analyze each report row and for any row containing balances, if all the balances are zero, that Excel row will be hidden.

![show-zeros-80](https://help.finaticalsoftware.com/hs-fs/hubfs/show-zeros-80.png?width=80&height=80&name=show-zeros-80.png)

Clicking the Show Zeros button will display all the hidden rows.

 

- [Documentation](https://help.finaticalsoftware.com/en/home/documentation?hsLang=en#main-content)

    - [Support](https://help.finaticalsoftware.com/en/home/documentation?hsLang=en#support)
- [FAQ](https://help.finaticalsoftware.com/en/home/faq?hsLang=en)
- [Support](https://help.finaticalsoftware.com/en/home/support?hsLang=en)
- [Flash Reports Claude Skill](https://help.finaticalsoftware.com/en/home/flash-reports-claude-skill?hsLang=en)

[![Finatical Software](https://help.finaticalsoftware.com/hs-fs/hubfs/finatical-software.png?width=200&height=35&name=finatical-software.png "Finatical Software")](http://finaticalsoftware.com)

<https://www.youtube.com/@finaticalsoftware/videos> <https://www.facebook.com/profile.php?id=61564155983162> <https://www.linkedin.com/company/finatical-software>

Copyright © 2025, Finatical Software