Workspace practice

Compare a spreadsheet with its source documents

Open the sheet at the rows and columns needed for one check, such as matching a transaction to an invoice. Give the sheet enough width to see the relevant identifiers and amount together. A neat layout is not useful if it hides the column that explains the number.

Decide which columns matter

Put the source document next to the sheet in a SlidePane strip. Place a reconciliation note on the other side or farther along the sequence. This keeps evidence and conclusions accessible without requiring all three windows to fit inside equal screen regions.

Preserve the application's own navigation

Normal scrolling inside a sheet should remain normal application scrolling. Begin workspace navigation with the keyboard or the configured modifier-plus-scroll action so you can distinguish moving through cells from moving through the strip. Test with non-sensitive sample data before doing important reconciliation.

Check one row, navigate to the source, then return to the same place in the sheet. If you lose the relevant row, use the spreadsheet's own selection and navigation tools; a window manager cannot preserve the meaning of a cell or verify the values.

Use simultaneous visibility selectively

If two amounts must remain visible at once, widen the source or try a stack only after checking that both views retain enough height. If the source is consulted briefly, alternating full-size windows may be clearer. Do not reduce text or application zoom solely to fit more window frames.

Save the workbook in its application before closing windows or switching tasks. Undo in SlidePane reverses layout actions, not spreadsheet edits. Read the horizontal guide for strip navigation and the recovery guide for returning surviving windows to their prior positions.

Cite or share this page

Dapols. "Compare a spreadsheet with its source documents." SlidePane, November 18, 2026. https://slidepane.com/en/blog/spreadsheet-and-reference-workspace

The link is stable. The citation uses the page's “Last updated” date.