Microsoft Office: Use Excel's I-Beam tool to swap data in 2 cells

By J. Carlton Collins, CPA

Q. Is it possible to swap the contents of two cells in Excel?

A. You can swap the contents of two cells in Excel if the cells are adjacent to each other. Here's how. In the example screenshot below, February is incorrectly positioned before January.

techqa-1


To swap the contents of cells A1 and B1 in one step, highlight cell A1 and then, while holding down the Shift key, click and drag the edge of the cell to the position between cells B1 and C1 until the green I-Beam icon appears (as circled in red below) and then release the mouse button.

techqa-2


February and January will switch places, or, more specifically, the word January in cell B1 will move to cell A1, while the word February in cell A1 will move to cell B1. The result is pictured below.

techqa-3


This trick works because holding the Shift key down while moving a cell instructs Excel to insert the cell's data, rather than overwrite the existing data. This trick works in any direction (up, down, left, or right). For example, in the screenshot below, I have positioned the I-Beam tool between cells A2 and A3 to swap the contents of cells A1 and A2.

techqa-4


This works with groups of cells as well. For example, in the screenshot below, I'm using the I-Beam tool to swap the Actual column with the Budget column.

techqa-5

About the author

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED REPORT

Tax reform changes are now in effect

With all the recent tax law changes, this year it’s more important than ever to make sure your clients’ tax situations are squared away before year end. This report provides necessary guidance to ensure 2019 starts without a hitch.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.