 In this video we're going to show you how to reverse the order of a list without having to manually copy and paste each row. First select your entire range and then start your formula with equals and the word index, open brackets and then first select the entire range of your existing list using F4 to lock both the start and the end position of that range. Next we're going to enter the word rows, open brackets and select that same range however if ever this time we're only going to enter F4 to the end part of our range. After that we'll close the formula and whilst holding the control button hit enter and you now have your list in reverse order. Don't forget to like and subscribe for more videos.