As you play around with your data, you might find you're constantly needing to add more rows and columns. Sometimes, you may even need to add hundredsof rows. Doing this one-by-one would be super tedious. Luckily, there's always an easier way.
To add multiple rows or columns in a spreadsheet, highlight the same number of preexisting rows or columns that you want to add. Then, right-click and select "Insert."
In the example below, I want to add an additional three rows. By highlighting three rows and then clicking insert, I'm able to add an additional three blank rows into my spreadsheet quickly and easily.