Copy Data to Adjacent Cells

**yoggags** · 05-05-2012, 03:01 AM

Hello,
I am yoggags a new excel user. I need some help in Copying data to Adjacent Cells
(Something similar to Ctrl R – but copying data to left column instead of right) is there any shortcut that someone can help me with? I use excel 2007
Thanks

**TMS** · 05-05-2012, 04:58 AM

Ctrl-C, move left, then Ctrl-V

Regards, Trevor

**yoggags** · 05-05-2012, 07:29 AM

Thanks Trevor, But I am looking for a "Drag" option, something similar to CTRL+R. I am quite sure there is some combination, that gives out the desired result without copy and paste option.

Regards,

**FDibbins** · 05-05-2012, 07:33 AM

if you want to copy to the left using "drag", hover the mouse over the bottom right corner of the cell you want to copy until it changes from a big cross to a small cross, hold the left mouse button and drag it to the left

**durga_ikon** · 05-05-2012, 07:45 AM

yogags,

do one thing, put =right(the cell). Then enter. Paste formula to the required cell, you are done !!

**FDibbins** · 05-05-2012, 07:51 AM

durga_ikon, unless i misunderstood you, all that will do is give you the last character on the right for that cell?

**durga_ikon** · 05-05-2012, 07:57 AM

he is asking for the same, he want the right data in left cell which copy pasting it. he can simply try pasting these formula and get rid of copy pasting repeatedly