If cells have been selected using the cell selection mode, the contents in the cells can be exchanged in pairs. The first two selected cells will have their contents swapped between them, and then the next two cells, and so on. If there are an odd number of cells, then the last selected item is not included in the swap.
- From the menu select Spread | Select | Swap Selected Cells.
The following image shows some cells before and after the values have been swapped. The cells were selected in the order A(1),B(1),A(3),B(3),A(5),B(5) using the Toggle Cell Selection menu item.