Autoshift cells down if I paste new data

[Legacy 185509]

Hello,

I want to know if I paste another data, I want whatever is there to shift down automatic
Thanks

 

[mikerickson]

To do that, don't use Paste, use Insert.
If you want, you could customize your keyboard so that cmd+V inserts rather than pastes.

 

[Legacy 185509]

oh man that would've worked so fine just found another problem,
those cells have formula, thats why I was going to use speical space and paste values only reason is that if I use insert then all the cells would same data/value

 

[mikerickson]

A (small) sample of the kind of data and formulas and your worksheet's lay-out would help us.

 

[Legacy 185509]

Hey Thanks for helping me I figured it out
I first did the special paste on sheet2 get ride of formula's then I copied the values from Sheet2 to Sheet3 and pasted it there for first time and other rest of the time I was able to use insert copied cells

Thanks again for help