There's always some simple thing I need to learn about how to use Excel. Today it was swapping columns without breaking my formulas.
How to swap columns in Excel tables by drag and drop and other ways to reorder columns. See how to move several adjacent and non-adjacent columns in a click in Excel 2016, 2013, 2010 and lower.