How to Move All Cells Down in Excel (5 Methods)

Moving all the cells down in Excel is pretty simple. Sometimes you may need to update your information in an Excel sheet. You may need to write new data above the previous information. For this reason, you require moving down all the cells containing previous data. I’ll show you 5 methods of how to move all cells down in Excel.


Download Practice Workbook


5 Methods of How to Move All Cells Down in Excel

Suppose we have the following dataset containing some information about different smartphones. We are going to show how to move the cells which contain these phones’ information down to the next row in the previous sections of this article. These information include their brand name, model name and price.

how to move all cells down in excel


1. Moving All Cells Down by Dragging Mouse

Imagine you want to put information about other smartphone brands above Samsung. So you need to move down all the data to the lower cells.

Steps:

  • To do this, select the range B5:D11. Then put the cursor on the marked area of the following figure.

  • You will see an icon. Now click on the icon and drag it down. If you want to put three new entries, then drag this icon up to 8th row.

how to move all cells down in excel by dragging mouse

  • Now release the cursor. You will see 3 empty rows above all the previous information.

By this way, you can easily move all the cells down to your desired row.

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


2. Inserting Rows to Move All Cells Down

You can also do this task by inserting new rows above Samsung Brand’s Smartphone information.

Steps:

  • Put your cursor on the marked area of the following figure to select a row.

how to move all cells down in excel

  • You will see an icon (marked in the figure). Now right click on it then select Insert..

  • A new row will appear. Thus you can move all the cells below.

how to move all cells down in excel

  • This new row contains the formatting of the previous row. You also can find a new icon (marked in the figure above).
  • If you want to change or clear the formatting, click on it. If you want the format same as the rows below, then click on Format Same As Below.

This will give you the format of the data of this chart.

how to move all cells down in excel

  • But if you want a completely new row without any format, select Clear Formatting.

This operation will give you a brand new row like the following figure.

how to move all cells down in excel inserting new row

Thus you can move all the cells down to one row.

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


3. Using Keyboard Shortcut to Shift All Cells Down

Using keyboard shortcut is also an effective method to do this. Let’s discuss the process.


3.1. Using ALT + ENTER to Move Cells Down

Using ALT + ENTER key is one of the easiest ways to move all cells down in Excel. Let’s see the process below.

Steps:

  • Think about how many new entries you want. If you want to insert 3 new entries, you need to  move these data to the 8th row. Now, select the range B5:D7.

  • Now just press ALT + ENTER.

how to move all cells down in excel

  • You will see all the cells move down to the 8th row. Now if you want to change or clear the formatting, click on the marked icon.
  • You will see 3 options. Click Format Same As Below if you want the format of the lower cells.

how to move all cells down in excel using keyboard shortcut

  • If you want completely 3 new rows, then select Clear Formatting.

You will see 3 completely new rows without any formatting.

how to move all cells down in excel

This way, you can also move all the cells of a dataset down to your preferred position.


3.2. Moving Cells Down by Cut and Paste Command

Another short cut method for moving all cells down in excel is using cut and paste command from keyboard. This method takes away the formatting of the cells though.

Steps:

  • Select the range B5:D11. Now press CTRL + X to cut the selected rows.

  • Think about how many new entries you want to insert. If you want to put 2 new entries, then select cell B7.

how to move all cells down in excel

  • Now press CTRL + V to paste.

You will see that all the data of smartphones move down to the 7th row creating 2 new entries. This operation costs you the formatting of the cells.

Read More: How to Shift Cells Down in Excel (5 Easy Ways)


Similar Readings


4. Using Insert Cells Command to Move All Cells Down

The process of moving all cells down in Excel can also be done by the Insert Cells command from the Insert ribbon. Think about how many rows these data will move down.
Steps:
If you want these data to start from the 7th row, select the range B5:D6.

  • Now select Home >> Insert >> Insert Cells.

how to move all cells down in excel

  • A dialog box will show up. Select Entire Row.

  • Now click OK. All these data will start from the 7th row.

how to move all cells down in excel

  • Now, to change or clear the formatting, click on the icon marked below.

  • Select Formatting Same As Below if you want the formatting of lower cells.

how to move all cells down in excel

  • The 5th and 6th rows will have the formatting of the lower cells.

  • If you want to clear the formatting, then select Clear Formatting.

how to move all cells down in excel

  • This operation will give you 2 new rows without any formatting.

Thus, you can move all the cells down below to where you want them to be.

You also can do this by right clicking on the mouse.

  • Select the range B5:D6. Then right click on any of the selected cells and select Insert.

how to move all cells down in excel

  • You will see a dialog box. Click Entire Row.

  • All the data will move down to the 7th row after this operation.

how to move all cells down in excel

  • Now, to change or clear the formatting, click on the icon marked below.

  • Select Formatting Same As Below if you want the formatting of lower cells.

how to move all cells down in excel

  • The 5th and 6th row will have the formatting of the lower cells.

  • If you want to clear the formatting, then select Clear Formatting.

how to move all cells down in excel

  • This operation will give you 2 new rows without any formatting.

Thus, you can move all the cells down below as where you want them to be.

Read More: How to Move Cells Up in Excel (3 Easy Ways)


5. Moving Cells Down by Inserting Blank Rows

We can move all the cells down by inserting blank rows above them.

Steps:

  • Think about how many rows you want to move down. If you want to start these given data from cell B7, then you need to move down 2 rows. So you need to copy any of the blank 2×3 cells ranges from the excel sheet as these data have 3 columns.
  • In this section, I will select range B13:D14 and press CTRL + C.

how to move all cells down in excel using blank cell

  • Now select cell B5 and right click on it. A Context Menu will appear.
  • From there select Insert Copied Cells.

  • Now select Shift Cells Down in the dialog box.

how to move all cells down in excel

You will see all the cells move down and start from the 7th row. This operation will clear out all the formats of the range B5:D6.

In this way, you can move all cells down in Excel to the desired row.

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


Practice Section

Here I’m giving you the dataset so that you can practice these methods on your own.

how to move all cells down in excel


Conclusion

This article provides some easy methods of how to move all cells down in Excel. I tried to cover all the possible ways of moving down all the cells containing data. If you have your own ideas or feedback or any question, please feel free to leave them in the comment box.


Related Articles

Tags:

Nahian

Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo