You can reverse the row or column order of a list in Excel by creating reference list, a Macro, and using INDEX function. We have explained all these methods.

How to Reverse a Column Order in Microsoft Excel. Reversing the order of a column would be easy if the column was already listed alphabetically or sequentially; you would just sort in the other ...

How to Identify One Word in a Cell in Excel. Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells.

We take a closer look at how you can use VLOOKUP if the cell contains a word within text in Excel, with three different examples.