Hidden rows can quietly leave transactions out of what you see and, depending on the formula, out of your totals. Check the row numbers for gaps, select the whole sheet and unhide rows and columns, then compare your debit and credit totals with the statement summary. File > Info > Check for Issues > Inspect Document finds the rest.
How can you spot hidden rows and columns?
- Row numbers skip, for example 14 then 17. Rows 15 and 16 are hidden.
- Column letters skip, for example C then E.
- A thicker line appears between the row numbers where rows are hidden.
- Blue row numbers and a funnel icon on a header mean a filter is hiding rows, which is a separate mechanism from hiding.
A formula check also helps. If your data sits in A2:A101, compare =COUNTA(A2:A101) with =SUBTOTAL(103,A2:A101). SUBTOTAL with 103 counts only visible cells, so a smaller result means rows are hidden or filtered.
How do you unhide everything?
- Click the small triangle at the top left, where the row numbers meet the column letters, to select the whole sheet.
- Right-click any row number and choose Unhide.
- Right-click any column letter and choose Unhide.
- If filters were on, choose Data > Clear, and check the sheet tabs. Right-click a tab and see whether Unhide is available, since whole sheets can be hidden too.
A row that was hidden by setting its height to zero usually reappears with Unhide, but if it does not, select the rows on either side and drag the row border down.
What does Inspect Document do?
Choose File > Info > Check for Issues > Inspect Document. Excel lists categories of hidden content. Tick Hidden Rows and Columns and Hidden Worksheets, and click Inspect. The result shows how many were found. The Remove All button deletes them, which is permanent for those cells, so use it only on a copy after you have checked what they contain.
How do you check against the statement total?
The statement's own figures are the reference. Say a statement shows an opening balance of ₹42,000, total credits of ₹85,000 and total debits of ₹61,500. The closing balance should be 42,000 + 85,000 - 61,500 = ₹65,500. Now total your own debit column. If it shows ₹58,300, then 61,500 - 58,300 = ₹3,200 of debits is missing, which suggests a hidden row, a filtered row or a text-formatted amount.
| Check | Formula or step | What a mismatch means |
|---|---|---|
| Sum of debits | =SUM(C2:C101) | A row is missing or an amount is stored as text |
| Visible-only sum | =SUBTOTAL(109,C2:C101) | If this is lower than SUM, rows are hidden or filtered |
| Row count | =COUNTA(A2:A101) against the statement | Compare it with the number of transactions listed |
| Running balance | Previous balance + credit - debit - this balance | A non-zero result marks the row after the gap |
What other ways can data hide?
- Text coloured the same as the background looks empty but still counts in totals.
- A custom number format of three semicolons shows nothing in the cell, although the value is there. Click the cell and read the formula bar.
- Very narrow columns look like a thin line between two letters.
- Rows inside a grouped outline can be collapsed with a small plus sign at the left margin.
In Google Sheets, hidden rows and columns show small arrows in the row and column headers. Click an arrow to bring them back.
A short routine for every downloaded file
Unhide all rows and columns, clear filters, count the rows, total the debits and credits, and match them to the statement summary before you categorise anything. Five minutes at this stage saves hours of hunting for a missing ₹3,200 later.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


