Lesson 4: Reversing an Excel List

Share on facebook
Share on linkedin
Share on twitter
Share on email
Share on print

This lesson follows on from the lesson: Sorting a range on colour

We shall now learn how to reverse a list in Excel.

Exercise

Please download the zip archive “Reversing a list”, extract and open the file Reversing a list.xlsx

We may, for example, want to reverse the list in column A below

Method 1

  • Enter the value “Rev” into cell F1, the value 1 into cell F2 and the value 2 into cell F

  • Select the range F2:F3.

  • Click the lower right corner of this range, and drag it down to cell F15 using the fill handle.

  • Select any cell in the list in column F.
  • On the Data tab, click ZA.
  • Result

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

Method 2

Method 2 uses a Multicell Array Formula to reverse the order of values in a worksheet range. This will, however, be covered in a lesson ahead as we explore Excel Formulae and Functions.

Thank you for your time and see you in the next lesson: RANDOMISING AN EXCEL LIST

 

Share this

More To Explore

#WinningMindspark

Motivating your staff

How do you get your staff morale through the roof to deliver value and smiles together to the bank? Many leaders think the primary cause of low energy is poor

Share this
Read Article »

Do you want to transform Business?

get in touch