Meraz Al Nahian
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.
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.
- 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.
- 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.
- 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.
- 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.
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.
- 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.
- If you want completely 3 new rows, then select Clear Formatting.
You will see 3 completely new rows without any formatting.
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.
- 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
- How to Delete a Cell in Excel (4 Easy Ways)
- Excel if One Cell Equals another then Return another Cell
- Selecting Non-Adjacent or Non-Contiguous Cells in Excel (5 Simple Methods)
- How to Select Multiple Cells in Excel (7 Quick Ways)
- Data clean-up techniques in Excel: Filling blank cells
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.
- A dialog box will show up. Select Entire Row.
- Now click OK. All these data will start from the 7th row.
- 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.
- The 5th and 6th rows will have the formatting of the lower cells.
- If you want to clear the formatting, then select Clear Formatting.
- 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.
- You will see a dialog box. Click Entire Row.
- All the data will move down to the 7th row after this operation.
- 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.
- The 5th and 6th row will have the formatting of the lower cells.
- If you want to clear the formatting, then select Clear Formatting.
- 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.
- 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.
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.
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
- How to Click One Cell and Highlight Another in Excel (2 Methods)
- How to Lock Cells in Excel When Scrolling (2 Easy Ways)
- [Fix]: Arrow Keys Not Moving Cells in Excel (2 Methods)
- How to Select Cells in Excel Using Keyboard (9 Ways)
- How to Select Cells with Certain Value in Excel (5 Methods)
- Select All Cells with Data in Excel (5 Easy Methods)
