When you purchase through links on our site, we may earn an affiliate commission.

The ability to view data from different perspectives -- whether greatest to least, or alphabetically -- is where Excel shines brightest.

Its not just a tool for collecting data, but viewing it as well.

Open an Excel workbook or create a new one.

Highlight the column you wish to sort.

Click the Filter icon under the Sort Filter heading.

Notice the drop down arrow placed to the right of the column heading.

Click the arrow to sort the data how youd like -- smallest to largest, or vice versa -- and press OK.

Click Sort in the pop-up warning.

Microsoft Excel Tips Previous Tip Next Tip Use VLOOKUP in Excel Back Up Files Automatically in Excel Remove Duplicate Data in Excel Create a Waterfall Chart in Excel Lock Cells in Excel Freeze Rows and Columns in Excel Build a Forecast Chart in Excel Create a Funnel Chart in Excel Make a Treemap in Excel Convert Excel Sheets to Google Sheets Open Google Sheets in Excel Combine Data from Different Cells Merge Cells to Span Multiple Columns Use AutoFill for Repetitive Data Copy and Paste Repetitive Data the Easy Way Use Text to Columns Draw Diagonal Line in a Cell Create a New Shortcut Menu Transpose Columns Using Paste Special.

Receive email from us on behalf of our trusted partners or sponsors.

You can unsubscribe at any time and well never share your details without your permission.

Slide Sorter On Excel For Mac