There is no such an option for shifting cells right. I think most users start
using a spreadsheet from left to right (I'm not about the Indian users. But
even Chinese users do.) Therefore, normally, cells near the far right hand
side of the spreadsheet is likely to be empty. So, there should normally be
no problem creating new cells at the far right when shifting cells to the
left.

If shift to the right, new empty cells will be creating on the left of the
worksheet, ie. column A, B, C, etc., which is likely to create problem in
most spreadsheets.

Therefore, normally, if you can allow the cells to shift right, you'd better
move the cells to the right instead.

The case is very similar to that extremely few users would start using a
spreadsheet from row 65536 and then upward. There will need to be an option
in Excel to allow the default startup selection of a worksheet in cell IV6536
then.

Regards,
Edwin Tam

http://www.vonixx.com




"CDWhite" wrote:

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.