drag value not format

[Guest]

Sheet has complicated formating with lines and fills. Need to lokc formating
but be able to drag cell values without the formating smearing over.
Can't figure it out by myself :-(

 

[Frank Kabel]

Hi
copy the source cell and paste it with 'Edit - Paste Special - Values'

 

[Guest]

Not really what I need. I want to find out how to be able to drag and
drag-fill without the formating following along. This to speed up work.

 

[Guest]

Not what I need. To speed up work on a big planning sheet I need to be able
to drag and drag-fill values without the formating "smearing" along. Cannot
find a way of locking the formatting without locking the cell values.

 

[Frank Kabel]

Hi
drag with your RIGHT mouse button pressed down and from the appearing
context menu after releasing the mouse button choose 'Fill without
formatting'

 

[Guest]

I have a similar problem...is there a way to go about this with just using
the LEFT mouse button?

Jennifer