Forum Discussion
How to insert a large amt of rows in the middle of a spreadsheet
How can I insert 820 rows in the middle of a spreadsheet without adding each row one by one and without overriding anything?
Let's say you want to insert 820 rows starting at row 612.
Press F5 to activate the Go To dialog.
Enter 612:1431 in the box, then click OK. This is a range of 820 rows, since 1431 = 612+820-1
Right-click any of the selected row numbers, then select Insert from the context menu.
Thank you for your reply but it won't allow me to type the #'s in the "box"? It just says Print Titles and I can't override that or type anything else.
If F5 doesn't activate the Go To dialog, try Ctrl+G, or click Find & Select > Go To... on the Home tab of the ribbon.
HansVogelaar - it worked, thank you very much!