Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Sort bank transaction by payee in Excel or Word 2010


01 Jan 2014   #1

Windows 7 64 bit
 
 
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 System SpecsSystem Spec
.

01 Jan 2014   #2

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

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 Images
 
My System SpecsSystem Spec
02 Jan 2014   #3

Windows 7 64 bit
 
 

Thank you!
My System SpecsSystem Spec
.


02 Jan 2014   #4

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Glad to help
My System SpecsSystem Spec
Reply

 Sort bank transaction by payee in Excel or Word 2010




Thread Tools



Similar help and support threads for2: Sort bank transaction by payee in Excel or Word 2010
Thread Forum
Word 2010-Mailings-Updating Excel Data-Office14/Queries & Permissions Microsoft Office
Office 2010 runs product configuration when opening Word and Excel Microsoft Office
EXCEL VBA Macro Sort Groups of Items Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
EXCEL Sort sequence in Foreign Lamguage Microsoft Office

Our Sites

Site Links

About Us

Find 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 03:11 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33