Often, you’ll find yourself needing to move cells in a spreadsheet. Fortunately, this is very easy to do. It only takes a few clicks. Let’s learn how to move cells in Microsoft Excel.
How to Move Cells in Excel
Consider a list of data containing several cells. You have multiple columns, and you want to move a pair of cells between columns. You might think that you need to re-type the data inside, but there’s no need. Excel makes moving cells a breeze.
To get started, begin by selecting the cells that you want to move. In this example, that’s cells B7 and B8. To select them, simply click and drag your cursor across the two cells.
Now, you need to figure out where you want to move the cells to. In order to keep the columns the same length, the empty cells C5 and C6 are a good option.
To make the move, hover your mouse over the green border that appears around the cells you have selected. You’ll see the hand icon appear.
Then, click and drag to begin moving the two cells. In the lower right corner of the selection, you’ll see Excel start to display a cell range. This is telling you where the two cells would be placed if you release your mouse cursor.
Move up and to the right, until you see C5:C6 appear in the preview. Release your selection, and Excel will drop it into place.
Note: Any cell contents that previously existed will be deleted, although Excel will display an Alert message prior to replacing any content. Keep this in mind before you start moving cells around your spreadsheets.
As you can see, Excel makes it easy to move cells. This is a quick way to change up the layout and format of any worksheet. Try it today.