If you need to insert a large number of blank rows, or you need to be more exact then I suggest simply using method 3 copying the number of blank rows that you need from the bottom of the worksheet and then inserting them where you need them. Then the blank cells will be inserted and the cells below will be shifted down. Click on Outline and then click on Group toolbar. Step 2: Select all row which needs to be in one group (As we can see the user is selected for March month data from the table) Step 3: Now go to the Data menu bar. This will most likely result in a dialogue prompt that allows you to select “shift cells down.” Step 1: Now, look at the below data in Excel Sheet which a user wants to be grouping. Then right click and select “Insert Copied Cells…” in the area you need to expand. You can also copy the number of row(s) you want by selecting them with CTRL + C and or right click and select copy. You could then easily select the 4 rows, repeat the process and then you would have 8 blank rows. This will result in the same number of rows you originally selected being copied below. Then right click anywhere within the selected range and select “Insert.” You can then select all of those blank 6 rows and repeat the process, but now it will be inserting 6 blank rows at a time for every + key press. The below picture is after pressing the + key 5 times. Now you can keep pressing the + symbol or hold it down and it will keep inserting blank rows. This will result in a single blank row being inserted below it. Then hold CTRL+SHIFT and press the + key.
Pick where you want to insert the multiple rows.
0 kommentar(er)
