Using Google™ Spreadsheets

Section 8. Inserting, Deleting, Moving, and Copying Data

There are times when you need to rearrange data on your worksheet—beyond simple sorting, that is. When you need to move data from place to place, duplicate certain cells, or delete something you don't like, it's time to learn Google Spreadsheets' cell, row, and column editing functions.

Inserting Rows and Columns

To insert a new row or column, follow these steps:

1. Position the cursor in the row or column where you want to insert a new row or column.
2. Click the Insert button.
3. Select whether you want to insert a row or a column.

Google Spreadsheets now inserts the new row above the selected row or the new column to the left of the selected column. The existing row or column is shifted either ...