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: Outlook Sorting Question

26 Oct 2010   #1
mborner

Windows 7 Pro/32 Academic. Build 7600
 
 
Outlook Sorting Question

I'm creating multiple columns in Excel 2007. For example; 10 rows in column "A", 10 rows in column "C" and 10 rows in column "E".

30 Items (cells) total.

What I'd like to do is sort them, A to Z, starting at 1A and ending at 10E.
Ic an't figure it out. I'm sure it's simple.
Thanks.


My System SpecsSystem Spec
.
26 Oct 2010   #2
richc46

Microsoft Community Contributor Award Recipient

Windows 10, Home Clean Install
 
 

I should be able to help you with this, since I am proficient in excel.

The columns and rows are already numbered.

Under the home tab, and on the right sort and filter is what you need, for further sorting.
Give me more information, if this is not precisely, what you need.
My System SpecsSystem Spec
27 Oct 2010   #3
mborner

Windows 7 Pro/32 Academic. Build 7600
 
 

Thanks, Rich. The Sort and Filter command is where I'm having issues. Seems I cannot sort more than one column at a time. With multiple columns selected, nothing sorts. I've tried "from column A" and then gone and selected "And then from column B" but it's a no go. I need the sorting to look like this;


Attached Images
 
My System SpecsSystem Spec
.

27 Oct 2010   #4
richc46

Microsoft Community Contributor Award Recipient

Windows 10, Home Clean Install
 
 

I think that you may not using the custom sort function. Take a look at this and see if it fits your needs
Sort data by multiple columns in Excel 2007 | Excel Digest
My System SpecsSystem Spec
28 Oct 2010   #5
clunkfish

Windows 7 Enterprise x64
 
 

Excel doesn't let you sort discontinuous blocks of data because it carries with it a significant risk of seriously messing up your data.

Are the columns between the columns you want to sort, empty? In your example, are columns B, D and F simply empty columns? If so, delete them, then sort the data as usual, then reinsert blank columns where you want them.

Hope this helps - though I may have misunderstood your question...
My System SpecsSystem Spec
28 Oct 2010   #6
richc46

Microsoft Community Contributor Award Recipient

Windows 10, Home Clean Install
 
 

Clunkfish is correct. But using custom sort, you are able to sort the data as shown in the example that I sent you.
My System SpecsSystem Spec
28 Oct 2010   #7
clunkfish

Windows 7 Enterprise x64
 
 

Quote   Quote: Originally Posted by richc46 View Post
Clunkfish is correct. But using custom sort, you are able to sort the data as shown in the example that I sent you.
The method given in Richc46's excellent link still won't allow sorting of discontinuous blocks of data - in other words, it would still sort columns B, D and F as shown in the OP's example. If I understand correctly, the goal is to sort columns A, C, E and G but leave B, D and F untouched. As far as I know, that isn't possible (and for good reasons).

If B, D and F are empty, they can be sorted without changing anything; if they contain data, won't the values need to remain associated with other data in the same row, and thus have to be sorted anyway?
My System SpecsSystem Spec
28 Oct 2010   #8
mborner

Windows 7 Pro/32 Academic. Build 7600
 
 

Thanks, clunkfish, for the update. To answer your question, no, columns B, D, and F are not empty, they contain numerical values. I don't want the numerical values sorted, though, just the alpha values.
My System SpecsSystem Spec
Reply

 Outlook Sorting Question




Thread Tools




Similar help and support threads
Thread Forum
outlook.com question
Does anyone know whether there is a limit of file size kept in Inbox ? Say, if someone keeps 15,000 mails in Inbox, will that affect the efficiency of receiving mails ? t-4-2
Browsers & Mail
Outlook 2010 - Inbox not sorting by 'From' field
The problem I'm having is that when sorting my inbox by 'From', it says no items are there and the bar spins along as if it's searching. If I choose to sort my inbox by anything else it works fine. I can also sort all other folders by every attribute, including 'From's so am unsure as to why I...
Microsoft Office
Outlook Express question
Not a Windows 7 problem but help is needed please. I cleaned up a friends computer yesterday, it had completely ground to a halt. It is now running fine except for one annoying problem. Outlook Express opens up fine and shows all the e mails. When she double clicks on one, or right clicks and...
Browsers & Mail
outlook 2007 question
i have a user when she attaches a file from her desktop to outlook, it takes about 5 mins to attach, but when she clicks and drag or copy and pastes to out look, it takes no time at all...i'm not sure what's going on here. any suggestions will be very helpful...just in case, made sure the files...
Microsoft Office
Outlook PST question
Is the PST file I have now made in Outlook 2010 64Bit version compatible in the Outlook 2010 32Bit version? As I was thinking of installing the 32Bit version as I have a few glitches in the 64Bit version. Steve
Microsoft Office
Microsoft Outlook Question
Hey folks I use Microsoft Outlook and am now on an open/unsecured network and it wont send any of my emails but it will recieve my messages, is there any setting (and how do I go about it) that will let me send emails?
Browsers & Mail


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:40.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App