To shift your cells 3 places to the right, ie, to shift A1, B1 and C1 to
C1, D1 and E1, select A1:C1 (3 cells for 3 spaces etc) and Insert, Shift
Cells Right
--
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.
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=532860