Written by Allen Wyatt (last updated August 29, 2019)
This tip applies to Excel 97, 2000, 2002, and 2003
Most sorting in Excel is done by row, meaning that you order the rows based on the contents of a particular column in the information being sorted. At times you may have a need to change the orientation of your sorting, meaning you need to sort columns based on the contents of a particular row.
Excel makes sorting by column easy, although it is not particularly intuitive. Simply follow these steps:
Figure 1. The Sort dialog box.
Figure 2. The Sort Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2709) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
When formatting the layout of your worksheet, Excel allows you to easily merge adjacent cells together. This can cause ...
Discover MoreNeed to sort your data based on the color of the cell? Excel doesn't include this capability, but you can still do the ...
Discover MoreWhen you sort data in a worksheet, you don't need to sort everything at once. You can sort just a portion of your data by ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2023-03-02 16:00:35
Allen
My guess, Stephen, is that the ones that are out of sequence aren't using a space between the words. It looks like a space, but is probably a different character, such as a non-breaking space.
-Allen
2023-03-02 13:37:25
Hi Allen
I have a list of data (text) in a column which will not sort correctly. I will give you an example
ABLAZING GRACE
ABLE BEAUTY
ABLE FAME
ABLE HIT
ABLE IVY
ABLE LASS
ABLE LOTTY
ABLE MAGPIE
ABLE MILLIE
ABLE QUEST
ABLE RAMON
ABLE SABLE
ABLE TO RUN
ABLE VIVA
ABLE BONNIE
ABLE CUSTOMER
ABLE FAME
ABLE LANE
ABLEBE
If I retype any of the wrongly sorted names ie ABLE LANE then do a resort, it puts the retyped name into it's correct position. How can I avoid having to go through the whole of my list, as I have over 90,000 lines
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2023 Sharon Parq Associates, Inc.
Comments