Excel Tricks 014 - How to swap cell values or rows or columns in Excel?
It is not easy to swap values in Excel basing on its own native functions, and I am tiring of using cut and paste manually. But with some simple coding in Autohotkeys and VBA, it is now possible.