How to Invert Data in Excel

How to flip data vertically so that the order is reversed in Microsoft Excel

Inverting data vertically in Excel can be achieved by creating a temporary column next to the column that you want to invert with values that range from 1 to n, where n is the data entries in the column that we want to invert.

Once the temporary column has been constructed, highlight the original column and the new column and navigate to the in-built sort function under the heading 'Data'. If your data set and temporary column has a header, then make sure to select 'My data has headers', from here use the 'sort by' option to select the temporary column and then change the order from highest to lowest. Click ok and your original data set should now be inverted.

[SindhuApatha]

thank you so much sir it made my work easier and quick thank you😁👋👍

[markostradingjourney]

Thank you so much! That's such a clever hack!

[anasjatt]

Welldone Its really impressive for me Atleast.InshaAllah you will gonna be at right path one day and achieve what the really the purpose of Life.

[Solryus]

Thanks for your videos. I can make my dad learn how to use a computer and i can ever learn maths with the other channel.