How to Sort Columns in Excel 2007

Save

Sorting Excel data columns can reveal new information, such as the highest sale amount or the affiliate with the lowest number of sales in a given month. You can also sort data in alphabetical order for an easy-to-read list of company names, people or other textual information. Excel lets you sort a spreadsheet by multiple columns; for example, you might first sort a list of products by price and then by rating to quickly see the most affordable top-rated items.

  • Open your spreadsheet file in Microsoft Excel.

  • Press "Ctrl" and "A" to select all the columns in your spreadsheet.

  • Click "Sort & Filter" near the right side of the ribbon.

  • Choose "Custom Sort."

  • Select the first column you want to sort on, such as Column A, in the first drop-down box.

  • Select the criterion on which you want to sort this column, such as the value of the cell or the cell color, in the second drop-down box.

  • Select your desired sort order, such as A-to-Z or smallest-to-largest, in the third drop-down box.

  • Click the "Add Level" button if you want to sort by additional criteria.

  • Check "My Data Has Headers" if your spreadsheet has a header row. If you check this box, Excel will leave the header row as the very top row. Otherwise it would sort your column headings as though they were data.

  • Click "OK." Your Excel spreadsheet is now sorted by columns according to the criteria you set.

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!