Removing columns on spreadsheet for reconciliation

[jspads]

I am constantly opening transaction history in excel from M&T bank

I am strictly posting credits to the account

I want to remove the debits column and all of its corresponding rows as well keeping only the credits

How do I do this

[kev_]

Without seeing the worksheet it's a bit of a guess. But one approach

Use Data filter
- apply filter on debit column
- select the individual values in debit column
- delete all those rows

should leave you with everything you want

EDIT
and I should have also added - then delete the debit column

[FDibbins]

Hi, welcome to the forum

If all the data you want to remove is in 1 (or more) column(s), and that column does not contain data you want t keep, click on the column letter at the top, and then either rt-click and select Delete, or click the Delete button on the Home tab/Editing/Delete

[jspads]

Where is the data filter located? Home tab? Data? Can't find it, I'm using excel 2010

[jspads]

I want to delete that colom and also the rows associated with those columns
debits.png

[kev_]

Put cursor in cell with text= "Trans Date".
Then click on DATA tab
Then click on "Filter"
Then click on the arrow at the top of the Debit column
Then select each individual value

[jspads]

Got it, thank you

[kev_]

You are welcome.
Thanks for the rep
Please click on Thread Tools at top of thread and mark thread as solved