basically on a particular spreadsheet when i right click a cell or bunch of cells, i do not have the usual "delete" option, i only have "delete row" which obviously deletes the ENTIRe row, when all i want to do is delete the selected cells.

I have no idea how this has happened, the sheet and workbook are not protected and it is excel2002.

any ideas?