Shortcut to copy cell values

[sdsurzh]

Hi,


1. Is there any shortcut to copy the cell value from right to left (Like what we have from left to right Cntr+R)

2. Is there any shortcut to copy the cell value from bottom to up (Like what we have from up to down Cntr+D)


Thanks,

Suresh Kumar S

 

[Luke M]

I know there's a way in VB...

[pre]

Selection.FillLeft
Selection.FillUp

[/pre]
If there's not a native shortcut, I suppose you could write some short macros with these codes and assign them to a keyboard shortcut. =/

 

[sdsurzh]

Thanks Luke M

 

[nazmul_muneer]

@Luke M

I also need this shortcut

Thank you


--Muneer

 

[Ashok Pai]

Hi,

Use Alt+E+I+L to copy left.

Regards,

Ashok