Google Spreadsheets lets you delete entire rows and columns or clear the contents of individual cells. To delete a row or column, follow these steps:
Google Spreadsheets doesn't let you delete a cell per se, only clear its contents.
To clear the contents of an individual cell or range of cells, follow these steps:
The contents of the selected cell(s) are now deletedeven though the cells themselves remain.
If you accidentally delete data you want to keep, don't panic! Google Spreadsheets includes an Undo option that lets you unwind your last command. All you have to do is click the Undo button at the top right of the workspace. Presto! You've undone your last delete and your data is back where it belongs.
Moving Data with the Cut and Paste Commands
Google Spreadsheets lets you move data from one place to another in your worksheet by cutting and pasting the data. The cut and paste procedure is similar to that used in most Windows-based applications.
To cut and paste data in your spreadsheet, follow these steps:
Google now moves the highlighted data to the new location.
Be careful when cutting and pasting data! When you use the Paste command, Google will paste the copied data over any data that previously existed in the target range. Be sure no important data resides in the target range.
You can also use the following keyboard shortcuts when cutting and pasting data: CutCtrl+X or Shift+Delete; PasteCtrl+V.
Copying data is similar to moving data, except that both the original data and the copied data remain in your spreadsheet. You can use the copy command to duplicate table headings or entire ranges of data.
To copy and paste data, follow these steps:
Google places a copy of the selected data in the new location.
You can also use the following keyboard shortcuts when copying and pasting data: CopyCtrl+C or Ctrl+Delete or Ctrl+Insert; PasteCtrl+V.