how to sort multiple columns in excel 2013

Navigate to 'Data' along the top and select 'Sort.' But the first name and house of each person needs to go with each last name that gets sorted, or each column will become mismatched when we finish sorting.Ģ. In the screenshot below, we're going to sort this sheet by the last name of Harry Potter characters. To sort a range of cells in Excel, first click and drag your cursor across your spreadsheet to highlight all of the cells you want to sort - even those rows and columns whose values you're not actually sorting by.įor example, if you want to sort column A, but there's data associated with column A in columns B and C, it's important to highlight all three columns to ensure the values in Columns B and C move along with the cells you're sorting in Column A. Highlight the rows and/or columns you want sorted. But don't worry - while the location of certain buttons might be different, the icons and selections you have to make are the same across most earlier versions of Excel. Choose how you'd like to order your sheet.įor this first set of instructions, we'll be using Microsoft Excel 2017 for Mac.If sorting by row, click 'Options' and select 'Sort left to right.'.

If sorting by column, select the column you want to order your sheet by.Navigate to 'Data' along the top and select 'Sort.'.Highlight the rows and/or columns you want sorted.

How to sort multiple columns in excel 2013