If you right-click in A1, it will give you the option to Insert & shift
cells right.
--
David Biddulph

"sby" wrote in message
...
Hi

I am a bit stuck, I want to update a worksheet but keep previous data in
another column but I am stuggling to find a way.
What i want to do is, A1 has my present data and when I update that data I
want the old data to automatically move to B1. This will enable me to keep
both the present and previous data without cutting and pasting data.

Can anyone help.


Regards

Steve