How To: Sort data by multiple columns in Microsoft Excel

Sort data by multiple columns in Microsoft Excel

Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If there is a blank column between, Excel will not group the date together. Click on a cell and click the sort icon. A pop up window will appear asking if you want to expand the selection? Clicking on this will group the columns and keep date in each line together. What if you want to sort by column B or column C? Then you will need to use the menu. Go to the menu select data and then sort. This will give the option of picking a single or multiple columns to sort by. If you have headers it will give the option of sorting by header name. Select the column you wish to sort by and click OK. Now you are a master of the sort function in Microsoft Excel 2003.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Other worthwhile deals to check out:

Join the Next Reality AR Community

Get the latest in AR — delivered straight to your inbox.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest