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.

Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.