You can swap the contents of two cells in Excel if the cells are adjacent to each other. Here’s how.

Tips More complex default value setting requires Excel Macro scripts to be written, for example, setting a different default value depending on the value of other columns in the spreadsheet.