#HOW TO SORT MULTIPLE COLUMNS IN EXCEL 2016 HOW TO#

#HOW TO SORT MULTIPLE COLUMNS IN EXCEL 2016 HOW TO#

Here's how to alphabetize a list in Excel: 1.

One example of sorting in Excel is alphabetizing list items. Confirm by hitting 'OK'įinalize your sorting choices by clicking the button at the bottom of the sorting window that says 'OK.' The window then disappears, and your data reorganizes itself according to the options you have selected in the sorting menu. You can use any combination of the options in the sorting window listed above to customize how your data is shown.

Customize your sorting optionsĭecide how you want your list to be sorted or the order in which you want your data to be displayed. Related: 10 Common Excel Formula Errors (And How To Fix Them) 4. To do so, click on 'Options' and choose 'Sort left to right' instead of 'Sort top to bottom.' Options: The top of the sorting window includes a button labeled 'Options' which can change the 'Sort by' option to rows instead of columns. If your list doesn't use headers, you can leave this box unchecked. Headers: The top right corner of the sorting window allows users to check a box to confirm that their list has headers, or cells at the top of each list they want to keep as they are. If your list contains numbers instead of letters, the order menu accounts for numerical order and offers the choice of 'smallest to largest' or 'largest to smallest.' Order: This dropdown menu lets you tell Excel how you want the data to be arranged, such as alphabetically from A to Z, reverse-alphabetically from Z to A or in a custom list, such as the days of the week. It lets users pick between aspects like cell value, cell color, font color or conditional formatting icon. Sort on: Use this dropdown menu to decide how the cells will be sorted. Any other highlighted data will sort according to the rules you establish for that column. Sort by: This option allows you to choose which column you want to use as the anchor for your sorting. The “Sort” button allows options for organizing that include: Navigate to the section in the “Data” menu that reads 'Sort & Filter' to view the sorting and filtering options. The ribbon also includes options for “File,” 'Home,' 'Insert'' and 'Draw.' 3.

Open the “Data” menuĬhoose the tab in the navigation bar at the top of the page-known as the ribbon-that reads 'Data' to reveal the options for manipulating data in the spreadsheet. You might choose to highlight single or multiple rows or columns, or both rows and columns, depending on how you want to reorganize your data. Highlight the data items you want to sortĬlick and drag your cursor to select all the cells you want to sort. Here are some general steps for sorting data in Excel: 1.

You can sort data in Excel in a few different ways, such as by cell color or numerical value. In this article, we explain the steps for sorting data in Excel. The most important benefit to learning how to sort in Excel is the time you save by using it to perform actions automatically. Sorting data could mean arranging prices in ascending value, alphabetizing a list of names or ordering a list of dates that appears out of sequence. Many companies want their employees to know how to use Excel for sorting data, especially in administrative jobs or positions that involve reading and filing large amounts of detailed materials. Microsoft Excel is a computer program that enables users to quickly organize and simplify data with spreadsheets, workbooks, graphs or charts. In this video, we’ll explain how to use the Sort function tool in Microsoft Excel to help you quickly sort, analyze and track your data. Related: How to Sort (and Unsort) Data in Excel

How to sort multiple columns in excel 2016