Sort bank transaction by payee in Excel or Word 2010


  1. gwatts
    Posts : 22
    Windows 7 64 bit
       New #1

    Sort bank transaction by payee in Excel or Word 2010


    I have downloaded all 2013 transactions from the bank into Excel. I want to sort the payees into itemized groups such as payments to the power company, cable television, payments for city utilities, etc.


    Is there a way to accomplish this in Microsoft Word 2010, Excel , or Open Office?

    Thank you.
      My Computer
    Quote Quote

  3. Slartybart
    Posts : 6,458
    x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
       New #2

    Click on the uppermost left hand ColumnRow to select all cells

    Find sort (data menu - sort in OpenOffice, but Excel has sort too)
    When the sort dialog winodw opens, select the COLUMN that contains payees (coulmn C in my example)

    Edit: the picture shows step 4 as Column B, it should be Column C
    Attached Thumbnails Attached Thumbnails Sort bank transaction by payee in Excel or Word 2010-datasort.png  
    Last edited by Slartybart; 01 Jan 2014 at 20:13.
      My Computer
    Quote Quote

  4. gwatts
    Posts : 22
    Windows 7 64 bit
    Thread Starter
       New #3

    Thank you!
      My Computer
    Quote Quote

  6. Slartybart
    Posts : 6,458
    x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
       New #4

    Glad to help
      My Computer
    Quote Quote

 

  Related Discussions
I am running Windows 7 Home Premium 64-bit and Office 2010. All of a sudden, when I tried to paste text I copied from an internet page, I got a message "Word could not create the work file. Check the temp environment variable" . It worked fine this morning and is working fine now. I had...
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Just started using a new workstation with Office 2010 installed by OEM. Everything worked fine for a few days, and then every time i attempt to open a Word file or Excel file i get the MS Office dialog box that states "please wait while windows configures Microsoft Office 2010". The dialog box...
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Hi all Seem to have an error when trying to sort data in excel -- I've installed the IS (Icelandic) language pack both on W7 and Office 2010 --no prob but when I sort I get the standard English sequence rather than the sequence : A Á B C D Ð E É F G H I Í J K L M N O Ó P Q R S T U Ú V W X Y Ý Z...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 00:36.
Find Us