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
gwatts

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
Slartybart

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
gwatts

Windows 7 64 bit
 
 

Thank you!
My System SpecsSystem Spec
.


02 Jan 2014   #4
Slartybart

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
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
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...
Microsoft Office
Word 2010 is opening my word 2003 attachments
I normally use Word 2003 for documents, although I use Outlook 2010. This morning I opened a Word 2010 document and after quite a while of some sort of an installation, I was able to open the Word 2010 document. I did not think too much of it, except that later I was sending an e-mail and attached...
Microsoft Office
Word 2007 Can't open encrypted docx from Word 2010
When I send some friends a password protected word document created in Word 2010 they can't open it using word 2007 which is compatible with docx by using the correct password. I have no choice but to send as a Word doc instead of docx so they can open it. Word 2007 User 1: Word launches no...
Microsoft Office
Office 2010 runs product configuration when opening Word and Excel
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...
Microsoft Office
Formatting Excel 2010, Excel 2003
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...
Microsoft Office
EXCEL Sort sequence in Foreign Lamguage
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...
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 17:31.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App