Easily Swap Cells, Rows, Columns or Ranges in Excel 2007/2010

Click "Kutools">>"Modify">>"Swap Ranges". See screenshots (Fig. 1 and Fig. 2).

Fig. 1 Swap Ranges		Fig. 2 Swap Ranges dialog box

Usage:

1. Open the workbooks you want to swap ranges;
2. Click Swap Ranges;
3. Click under the Swap Range 1 to select one range; Note that labels indicate the number of rows and columns for each range selection box (the number of rows and columns for the two ranges must be identical).
4. Also click under the Swap Range 2 to select another range;
5. Click OK; See screenshots (Fig.3 and Fig.4).

Fig.3 Before swap ranges

Fig.4 After swap ranges

Note:

1. The formatting and formulas in the ranges will also be swapped.
2. Support swapping entire rows or columns.
3. The cells or ranges can reside not only on the same sheet, but also on different sheets or in different workbooks.
4. This operation supports Undo. If the result is not what you want, you can press Undo (Ctrl +Z) immediately to restore it.
5. The two ranges to swap must be of identical size.(i.e., the same number of rows and columns)

See Swap Ranges feature demo (video 1)

This is only one feature of Kutools for Excel

It includes more than 100 functions and tools for Excel 2007 and 2010.