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?
4 Replies
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.
