I've figured out why Excel does this. I was using a filter on one of
the columns. If you're using a filter then it only comes up with the
'Delete Row' option. If you take the filter off so you're viewing all
the data then it allows you to delete cells.
--
SandyW
------------------------------------------------------------------------
SandyW's Profile:
http://www.excelforum.com/member.php...o&userid=35892
View this thread:
http://www.excelforum.com/showthread...hreadid=544900