Switching rows and columns
There’s a third kind of “paste special” that I haven’t discussed yet — transposing. When you paste transposed, you’re switching the rows and columns with each other. The cell in C1 (3rd column, 1st row) swaps places with cell A3… Read moreSwitching rows and columns