Sort Data With Headers in Ascending Order in Excel

Add to Favorites
Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it. This means that you data has a row that labels what the data underneath it is or stands for in the worksheet. The header row will not be sorted; however everything underneath that row will be sorted. Header rows are assumed to be one single row in Excel. This means that if your header row is actually two rows, you need to account for this by moving the data table range that you will list in the macro down one.

This macro sorts one column within the data set. This is a simple sort macro for Excel and works in most versions of Excel.

To use this Excel macro, simply replace A1:C56 with the range of the entire data table that will be changed or re-arranged by the sort and then change A1 to point to the column or top cell in the column of the data from which you would like to sort the entire data set.

Where to install the macro:  Module

Excel Macro to Sort Data With Headers in Ascending Order in Excel

Sub Sort_Ascending_With_Header()
'Sorts a worksheet in ascending order and assumes there are headers on the data

Range("A1:C56").Sort _
Key1:=Range("A1"), Header:=xlYes

End Sub

How to Install the Macro
  1. Select and copy the text from within the grey box above.

  2. Open the Microsoft Excel file in which you would like the Macro to function.

  3. Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.  Or For other ways to get there, Click Here.

  4. On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.

  5. If the Macro goes in a Module, Click Here, otherwise continue to Step 8.

  6. If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.

  7. If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.

  8. Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.

  9. You are now ready to run the macro.

Excel Forum