Adding and deleting rows and columns is a common (and necessary) function in spreadsheet applications. Doing this in Google Spreadsheets is quite simple and painless. Read on to find out how this is done.
To add a row or column to a spreadsheet, right-click on the shaded area containing the column letter or row number. Select Insert left or Insert right.
To remove a column or row, select Delete column or Delete Row.
To insert multiple rows or columns, highlight the number of rows or columns to insert before right-clicking the shaded area.