Inserting rows in a spreadsheet [closed]
Hi: Is there a way to insert many rows in a spreadsheet without doing it manually, one row at a time.I have to insert 2 rows at every other row 400 times. I can do it with a macro but still have to insert manually the first time. Thanks, Bill
Select the bunch of cells that how much you wanted the number of cells to be inserted.. Copy it. Then Ctrl+Shift+V(Paste Special option). Suddenly Paste Special Dialog box popped up. In That dialogue box,at the bottom Shift cells option,select down and then click ok. you will get doubled with same formatting cells. Try it!