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

Data Analysis

  • How to combine 2 or more chart types in a single chart in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Everything about Charts in Excel
  • Create Scatter Chart in Excel
  • How To Remove Duplicates In Excel Column Or Row?

References

  • Two-way lookup with VLOOKUP in Excel
  • Excel Advanced Lookup using Index and Match Functions
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Find closest match in Excel
  • Perform case-sensitive Lookup in Excel

Data Validations

  • Excel Data validation only dates between
  • Excel Data validation don’t exceed total
  • How To Create Drop-down List in Excel
  • Excel Data validation allow uppercase only
  • Excel Data validation allow weekday only

Reverse List in Excel

by

This chapter teaches you an easy way to reverse a list in Excel. For example, we want to reverse the list in column A below.

1. Enter the value 1 into cell B1 and the value 2 into cell B2.

2. Select the range B1:B2, click the lower right corner of this range, and drag it down to cell B8.

3. Click any number in the list in column B.

4. To sort in descending order, on the Data tab, in the Sort & Filter group, click ZA.

Result. Not only the list in column B, but also the list in column A has been reversed.

Post navigation

Previous Post:

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

Next Post:

Excel Data validation require unique number

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

  • Nested IF function example in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel FALSE Function
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel NOT Function

Date Time

  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Calculate number of hours between two times in Excel
  • Get days before a date in Excel
  • Pad week numbers with zeros in Excel
  • Steps to create Dynamic calendar grid in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • Group times into unequal buckets in Excel
  • If cell contains one of many things in Excel
  • Group numbers at uneven intervals in Excel

General

  • Subtotal by color in Excel
  • Using Existing Templates in Excel
  • Count cells less than in Excel
  • How to Insert Cells, Row and Rows in Excel
  • How to generate random times at specific intervals in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning