Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Left Lookup in Excel
  • How to use Excel INDIRECT Function
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • Excel Pie Chart
  • How To Load Analysis ToolPak in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • How to Create Area Chart in Excel
  • How To Insert and Customize Sparklines in Excel

Data Validation Examples

  • Excel Data validation must not contain
  • Data validation must not exist in list
  • Excel Data validation specific characters only
  • Excel Data validation date in specific year
  • Excel Data validation with conditional list

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.

Worked Example:   Advanced Filter in Excel

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

Worked Example:   How To Remove Duplicates In Excel Column Or Row?

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.

Worked Example:   How to Sort by Color in Excel

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

Post navigation

Previous Post:

Randomize/ Shuffle List in Excel

Next Post:

How to Sort by Color in Excel

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
  • FIND, FINDB functions: Description, Usage, Syntax, Examples and Explanation
  • How to convert numbers to text using TEXT function in Excel
  • How to extract text between parentheses in Excel
  • Remove unwanted characters in Excel
  • TEXTJOIN function: Description, Usage, Syntax, Examples and Explanation
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Sum through n months in Excel
  • How to calculate nth day of year in Excel
  • Display Days until expiration date in Excel
  • Calculate days remaining in Excel
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • Compound Annual Growth Rate CAGR formula examples in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles