How to always insert a blank row below instead of above in Excel?
As we all known, when inserting blank row in a worksheet, the blank row will always be inserted above the selected row or cell. But, sometimes, you may need to insert the row below the selected cell or row. How could you solve this job in Excel?
This article, I will talk about inserting blank row below the selected cell or row by clicking a button. Please do with the following steps:
1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
2. Then, click Insert > Module, and paste the following macro in the Module Window.
VBA code: Always insert blank row below instead of above
Sub InsertRowDown() 'Updateby Extendoffice Dim xRg As Range On Error Resume Next Application.ScreenUpdating = False Set xRg = ActiveCell.Offset(1, 0) xRg.EntireRow.Select Selection.Insert Shift:=xlDown Selection.ClearFormats Application.ScreenUpdating = True End Sub
3. Then, save and close this code window. Next, please click Insert > Shapes > Rectangle, see screenshot:
4. Then, draw a rectangle button with dragging the cursor and format it as you need. See screenshot:
5. After formatting it to your need, please right click it, and choose Assign Macro option, see screenshot:
6. In the Assign Macro dialog box, select the macro name you inserted just now from the Macro name list box, see screenshot:
7. Then, click OK to close the dialog box. Now, when you click any cell, and then click the button, the blank row will be inserted above the selected cell as below demo shown:
More relative insert rows articles:
- Copy And Insert Row Multiple Times Or Duplicate The Row X Times
- In your daily work, have you ever tried to copy a row or each row and then insert multiple times below the current data row in a worksheet? For example, I have a range of cells, now, I want to copy each row and paste them 3 times to the next row as following screenshot shown. How could you deal with this job in Excel?
- Insert Blank Rows When Value Changes In Excel
- Supposing you have a range of data, and now you want to insert blank rows between the data when value changes, so that you can separate the sequential same values in one column as following screenshots shown. In this article, I will talk about some tricks for you to solve this problem.
- Insert Multiple Rows Or Columns Quickly In Google Sheets
- This article, I will introduce an easy way to insert multiple blank rows or columns in a google sheet.
- Insert Blank Row Above Specific Text In Excel
- When you work on a worksheet, have you ever tried to insert blank row above a specific text in a column? For example, there are some names in column A, now, I want to insert blank rows above the cells which contain the name “Mike” as the left screenshot shown, maybe, there are no direct way for you to solve this task in Excel. This article, I will talk about some good tricks for dealing with this job in Excel.