So, how do we reverse the order of data in excel is the question now.

We cannot reverse just by sorting the data but with some helper column, we can actually do this.

Even though we dont have any built-in function to do this we can make use of other formulas to reverse the order.

Where Is Arrange In Excel Code For You

If you have good knowledge of VBA then below is the code for you.

First I have declared two variables k LR as a LONG data type.

Where Is Arrange In Excel How To Reverse Order

Here we discuss how to reverse order of data using 1) Sort Method 2) Excel Formula 3) VBA Code.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

Learn how to use conditional sorting in Excel to sort by font color, cell background color, or icon color.

Excel can automatically include related data in a range so long as there are no blank rows or columns within the selected area.

Blank rows and columns between areas of related data are okay.

Excel then determines if the data area has field names and excludes those rows from the records to be sorted.

Allowing Excel to select the range to be sorted is fine for small amounts of data.

However, for large areas of data, the easiest way to ensure that the correct range is selected is to highlight it before sorting.

If the same range is to be sorted repeatedly, the best approach is to give the range a name.

If a name is defined for the range to be sorted, type the name in the Name Box, or select it from the associated drop-down list.

This way, Excel automatically highlights the correct range of data in the worksheet.

When sorting by values, there are two possible sort orders: ascending and descending.

However, when sorting by colors, no such order exists, so you must manually define the color sort order.

In the example below, the records of students age 20 and younger are highlighted in red.

To sort the data by cell background color so that the red entries appear on top.

Highlight the range of cells to be sorted (cells A2 to D11 in the example).

Choose On Top from the drop-down list next to the sort order box so that the red cells will be at the top of the list, then select OK.

The four records with red backgrounds are grouped together at the top of the data range.

In the example below, the records of students enrolled in nursing programs appear in red, and those enrolled in science programs are blue.

Choose On Top from the drop-down list next to the sort order box so that the red entries will be at the top of the list.

Use the same settings as the first sort level, but this time select the Order drop-down arrow and choose Blue.

The two records with the red font color are grouped together at the top of the data range, followed by the two blue records.

Icon sets offer an alternative to regular conditional formatting options that focus on the font and cell formatting changes.