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.

You can show File Path on Title Bar in Excel and Word by creating and running a Macro - and even in Quick Access Toolbar too. This post explains the process in detail.

They essentially provide you with the ability to create a set of instructions that can be grouped and launched with a simple combination of keys.

A word of warning Before using macros, you’ll want to make sure the security settings in both Word and Excel are set not to run macros automatically. In the early days, any macro that was ...