Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Sort by Color in Excel
  • Error Bars in Excel
  • Excel Bar Chart
  • How To Load Analysis ToolPak in Excel
  • How To Remove Duplicates In Excel Column Or Row?

References

  • Approximate match with multiple criteria in Excel
  • Last row number in range
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to retrieve first match between two ranges in Excel
  • Multi-criteria lookup and transpose in Excel

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation must not contain
  • How To Create Drop-down List in Excel
  • Excel Data validation unique values only
  • Excel Data validation require unique number

How To Sort One Column or Multiple Columns in Excel

by

You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.

Navigation: Data Tab → Sort & Filter Group → Sort

One Column

To sort on one column, execute the following steps.

1. Click any cell in the column you want to sort.

2. To sort in ascending order, on the Data tab, in the Sort & Filter group, click AZ.

Result:

Note: to sort in descending order, click ZA.

Multiple Columns

To sort on multiple columns, execute the following steps.

1. On the Data tab, in the Sort & Filter group, click Sort.

The Sort dialog box appears.

2. Select Last Name from the ‘Sort by’ drop-down list.

3. Click on Add Level.

4. Select Sales from the ‘Then by’ drop-down list.

5. Click OK.

Result. Records are sorted by Last Name first and Sales second.

Post navigation

Previous Post:

TRUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Pie Chart

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • Not Equal To ‘<>‘ operator in Excel
  • IF with wildcards in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function

Date Time

  • Steps to create Dynamic calendar grid in Excel
  • Get fiscal quarter from date in Excel
  • How to calculate Next working/business day in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Convert decimal seconds to Excel time

Grouping

  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • If cell contains one of many things in Excel
  • Map text to numbers in Excel
  • Group numbers at uneven intervals in Excel

General

  • Basic numeric sort formula in Excel
  • How to calculate percent change in Excel
  • How to choose page/paper size in Excel before Printing
  • Count cells that contain errors in Excel
  • How to create dynamic named range with INDEX in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning