Select a Column in a PDF Instead of the Whole Page

To select a column in a PDF, use a reader with box selection: hold Option while dragging in Preview on a Mac, or hold Ctrl and drag an area in SumatraPDF on Windows. You then copy just the amounts, paste them into one Excel cell, and each value lands on its own row, ready to check against the statement total.

Why does PDF text selection grab whole lines instead of a column?

Normal PDF text selection follows reading order, left to right and then down, the way you would select a paragraph. On a statement, a reading line is a whole transaction row, so dragging down the amount column picks up every date and description in between. Box selection ignores reading order and takes only what sits inside a rectangle.

That is why copying a statement normally lands in Excel as one long column of mixed text. You can fix that paste with Text to Columns, but if you only need one field, such as the amounts for a total or the dates for a count, a box selection gets you a clean column with nothing to split.

Box selection only works when the PDF contains real text. A statement downloaded from online banking usually does. A scanned paper statement is a picture of text, and a reader cannot select characters it does not have.

Selecting a PDF column on a Mac with Preview and the Option key

Preview on a Mac selects a column of text when you hold the Option key while you drag. Apple's guide to selecting and copying text in a PDF in Preview describes this method as useful for copying a column in a table. You choose the Text Selection tool first, then Option-drag.

The steps:

1. Open the statement in Preview.
2. Choose Tools, then Text Selection.
3. Hold Option and drag a rectangle around the amounts, from the first one on the page to the last.
4. Choose Edit, then Copy.

Do not confuse this with Rectangular Selection, a different tool in the same menu. It copies a region as an image, which Excel cannot add up. If what you paste shows as a picture, you used the wrong tool.

Box selection of a PDF column on Windows with SumatraPDF

SumatraPDF, a free Windows reader, selects a rectangle when you hold Ctrl and drag with the left mouse button. Its list of keyboard shortcuts describes this as selecting an area that you can then copy. Drag around the amount column, press Ctrl+C, and paste into Excel.

The steps:

1. Open the statement in SumatraPDF.
2. Hold Ctrl and drag a box around the column you want.
3. Press Ctrl+C.
4. Paste into Excel and check you got text, not a picture.

Other Windows readers have similar features, and the keys differ by version. Whichever reader you use, test on one page and look at what the paste gives you before you work through a whole statement.

How do you paste a copied PDF column into Excel in one go?

Click one empty cell and press Ctrl+V. Excel puts each copied line on its own row, so a column of 25 amounts fills 25 cells going down. Then check two things: the count of cells matches the count of lines on the page, and the sum matches the page or statement total.

Here is a paste-and-check routine with example values:

1. Select A2 and paste. The amounts fill A2 to A26, which is 25 values.
2. In a spare cell, type =COUNT(A2:A26). If it returns 25, every value is a number. If it returns less, some pasted as text.
3. Fix text values. A dollar sign, a trailing minus or a "CR" suffix keeps a value as text. Replace them with Find and Replace, then use Text to Columns on the column to turn it into numbers.
4. Type =SUM(A2:A26) and compare it with the statement's printed total for those lines.

If the count is right and the sum matches, the column is done. The whole routine takes a couple of minutes for a page, against several minutes to type 25 amounts by hand.

PDF column selection edge cases: wrapped lines and page breaks

Box selection goes wrong in predictable ways. A description that wraps to a second line can push an amount out of line with its row. A page break means one box per page. Headers and subtotals inside the box come along too. Each one makes the pasted column longer or shorter than the statement.

• Page breaks. Select and paste one page at a time, each below the last.
• Headers in the box. Start the box below the column heading, and end it above any "Total" line, or delete those rows after pasting.
• Two amount columns. Many statements print debits and credits in separate columns. Copy each with its own box, into its own column, so the signs stay clear.
• Empty cells. Where a row has no debit, the debit column has a gap. A box selection drops the gap, so the pasted debits no longer line up with their dates. Copy one column only when you need totals, not row-by-row matching.

That last point matters most. If you need dates, descriptions and amounts lined up row by row, a single column copy will not give you that.

When rekeying beats selecting a column in a PDF

Rekeying beats column selection when the PDF has no text to select, when you need only a few values, or when the column has so many gaps and wraps that fixing the paste takes longer than typing. A scanned statement is the clearest case: nothing can be selected at all.

The trade-offs of typing data again are covered in what rekeying data costs and when it is worth it, and manual data entry vs OCR per page compares typing a scanned page with running OCR on it. The underlying arithmetic for a full statement is in what manual data entry costs per statement.

If you need every column lined up, not just one, a converter is the faster route. CheapBankConvert turns a text-based PDF statement into CSV or Excel with amounts stored as numbers, for an early price of $2.99 up to 10 pages; it is not open yet, so get started to hear when it is. Paying someone instead, the cost explained in how much a bookkeeper costs, makes sense when you need the books kept, not one column copied.