How to Move a Group of Cells in Excel (4 Easy Ways)

Sometimes, we have to move a group of cells in Excel depending on dataset orientations. There are multiple ways to move a group of cells whether they exist in rows or columns or range. Let’s say, we have a dataset that sits monthly sale data for different products. We want to move a group of cells existing in the dataset in columns or rows or ranges. Excel’s various features and keyboard shortcuts move cells with ease.

Dataset-Move a Group of Cells in Excel

In this article, we use multiple Excel features and keyboard shortcuts to move a group of cells in Excel.


Download Excel Workbook


4 Easy Ways to Move a Group of Cells in Excel

Method 1: Using Excel Cut and Paste Feature to Move a Group of Cells

From our dataset, we want to move the Total Sale column right from the current position within the worksheet. For that Excel offers the Cut and Paste option to achieve the goal.

Step 1: Select the entire Total Sale column then Right-Click on it.

The Context Menu appears. From the Context Menu options, select Cut.

You can use CTRL+X to execute Cut.

cut and paste -Move a Group of Cells in Excel

Step 2: Now, select blank cells where you want to move the Cut cells.

Right-Click on the selected cells, the Context Menu appears.

From the Context Menu, Click on the Paste icon under Paste Options.

You can use CTRL+V to execute Paste.

Paste option

In a moment, you see the Total Price column moved in the desired position as shown in the following picture.

Cut and Paste result

You can move any range of cells using the Cut and Paste operation.

Read More: How to Group Cells in Excel (6 Different Ways)


Method 2: Move a Group of Cells Using INSERT Feature in Excel

Another Excel feature named Insert can move a group of cells. The Insert Cells feature offers 4 options (i.e., Shift Cells Right or Down, Entire Row or Column), and we can choose one of them to move a group of cells.

Step 1: Select the range you want to move the cells of. Then, go to the Home tab > Select Insert (from the Cells section) > Select Insert cells (from the options).

insert-Move a Group of Cells in Excel

Step 2: The Insert window appears. From the Insert window, Choose the Shift cells right options (you can choose one of the options according to your need).

Click on OK.

Insert window

Clicking on OK moves the range 1 column right as shown in the latter picture.

Final result

🔁 The Insert feature offers other options such as Insert Sheet Rows, Insert Sheet Columns to insert rows or columns. The insertion of columns or rows moves a group of cells 1 column or row right or left.

Steps: Go to the Home tab > Select Insert (from the Cells section) > Choose any 1 of the options (i.e., Insert Sheet Rows or Columns).

insert-Move a Group of Cells in Excel

In this case, we use the Insert Sheet Columns option to move the Total Sale column to right.

Column insertion

You can use the Insert Sheet Rows option to move any row downward from its position.

Read More: How to Move Cells Down in Excel (7 Methods)


Similar Readings


Method 3: Moving a Group of Cells Using Select and Drag Trick in Excel

Excel offers some inbuilt tricks that allow users to modify their worksheets using operations like moving, copying, or replacing cells. As a result, Excel’s Select and Drag trick is handy in moving a group of cells within the dataset.


🔁 Moving Column

Step 1: Select the cells or a group of cells (i.e., Total Sale column) that you want to move. Then, move the cursor to the edge of the selection. By doing so, the cursor displays the all-direction icon as depicted in the below picture.

Select and drag-Move a Group of Cells in Excel

Step 2: Afterward drag the cursor anywhere (i.e., Column F) you want to display the column you just selected. During the moment of dragging, you can see the exact same range of the cells selected (i.e., E4:E16=F4:F16).

Moving range selection

After releasing the cursor, you can find Excel moves the selected range as you selected and dragged.

Final result


🔁 Moving Row

 Similar to columns, we can move any row or rows using the Select and Drag operation.

For row or rows, select the row or rows then move the cursor towards the edge of your selection until it turns into the all-directional select icon.

Row moving-Move a Group of Cells in Excel

Drag the cursor anywhere (here downward) to replace an existing row as shown in the below picture.

Replacing

The replacement causes removing the row entry (i.e., Rice) from the dataset as shown in the execution image.

Replaced row

You can just place the selected row in any blank row similar to the below image.

Moving in blank row

Placing rows in blank rows results in a discontinuity in the dataset. If this execution results in no alteration to your dataset, then you are good to perform it.

Final result

In order to keep things simple, we demonstrate only 1 row moving operation. Moving multiple rows is the same as single row movement.

Read More: How to Drag Cells in Excel Using Keyboard (5 Smooth Ways)


Method 4: Using Keyboard Shortcuts (SHIFT and Mouse Click)

Excel Select and Drag trick has an alternation. We can use keyboard shortcuts to move columns or rows around in a dataset. Keyboard’s SHIFT key enables us to switch columns or rows in a dataset. Let’s say, we want to switch the February’22 Sale column with January’22 Sale column. Also want to switch two random rows.


🔁 Switching Column

Step 1: After selecting the entire column, move the cursor towards the edge of the selection. Wait until the all-direction select icon appears.

keyboard shortcuts -Move a Group of Cells in Excel

Step 2: Hold the SHIFT key, then, Click on the edge. You see the all-directional select icon disappears.

Click on edge

Step 3: By holding the SHIFT key move the cursor to any direction (i.e., left, right, up, or down). In this case, you move the cursor left to switch columns. Excel displays switching selection (i.e., C4:C16) as Excel is ready to switch the columns.

Moving towards destination

➤ In a moment, Excel switches columns as depicted in the following picture.

Switched


🔁 Switching Row

Identical to the executions of column switching, we can switch rows.

➤ Repeat Steps 1 and 2 of column switching.

Row switching

➤ Repeating the operations for rows, you get a final outcome similar to the image below.

Final result

Switching or moving single or multiple columns or rows are pretty common in Excel daily usage. Keyboard shortcuts (SHIFT + Mouse Click) are dynamic to move a group of cells around the dataset.

Read More: How to Move Selected Cells in Excel with Keyboard (4 Methods)


Conclusion

In this article, we use multiple Excel features as well as keyboard shortcuts to move a group of cells in Excel. Excel’s Cut and Paste, Insert features allow cells to move wherever you want. However, Excel’s Select and Drag operation replaces columns or rows in case of pre-existing entries in columns and rows in the moving range selection. Hope you find these above-described methods workable with your dataset. Comment, if you have further inquiries or have anything to add.


Related Articles

Tags:

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo