How can I insert multiple rows of external data without overwriting the rows below?

Sam Mohyee

Oftentimes I'll copy rows from excel, email or my browser intending to insert those rows between used rows in my smartsheet. Although Smartsheet recognizes that I am pasting multiple rows, by default it will overwrite existing rows on the sheet rather than inserting new ones.

 

This means that if I want to paste in between existing rows, I have to first insert the exact number of new blank rows I need, then paste, which is a pain. Alternatively, for large lists, I have to scroll down to the bottom of the sheet where the blank rows are, paste, then move those rows back up to the desired location. This is also a pain.

 

Is there a way for me to insert external data into smartsheet without it overwriting existing rows?

Travis

As you have seen, when you paste data into a sheet, it will paste data into the existing rows. If you want the data added to new rows, you will need to insert new rows. As a quicker way to add rows, highlight the number of rows you want to add, right click and select Insert X Rows Above. The "X" will be the number of rows you highlighted. For example, if you highlight 10 rows, you can add 10 blank rows above.