Deleting cells prompts for shifting cells left, but not right. How can I
shift cells right?

I am working data records (rows) with seven fields (columns); for example:

1/1/2005 2/1/2005 3/1/2005 BLANK BLANK BLANK BLANK

How can I shift the data to the right?

BLANK BLANK BLANK BLANK 1/1/2005 2/1/2005 3/1/2005

I orignally tried selecting BLANK cells and deleting but I can only shift
left. Is there
another way?

Thanks.