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

--
Regards
Frank Kabel
Frankfurt, Germany

RCbear wrote:
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

RCbear wrote:
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 :-(