drag value not format

R

RCbear

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 :-(
 
R

RCbear

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.
 
R

RCbear

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.
 
F

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'
 
A

Arkitech

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

Jennifer
 
Top