drag value not format
 

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

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

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.

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

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

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

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

Jennifer

"Frank Kabel" wrote:

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