If I understand correctly, you have a filter on yoru data, and you have it
activated on a cell. You are trying to delete one cell and have all data move
left instead of just deletign the entire row. Far as I know, thsi cannot be
done. If possible, sort the data instead. Then, you can delete one cell at a
time.

"Gibbo" wrote:

When I want to delete a single or multiple cell my drop down screen on allows
me to populate the 'entire row or column? the shift cell left or up won't
allow me to select? I haven't proptected the sheet and I have tried
everything I casn think of to find the answer....please help if you can