I'm sorry Pete - I must not be doing a great job of explaining what I need. These guys want to be able to select a row and hit delete and erase all the contents except the cell contents in column A. They don't want to just go to column B and hold shift and highlight over and delete(and I don't understand why they can't just do that) but they want to be able to select the row and hit delete and have all contents on the row deleted except column A. I apologize that I wasnt more clear.