| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 :-( |
|
#2
|
|||
|
|||
|
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 :-( |
|
#3
|
|||
|
|||
|
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 :-( |
|
#4
|
|||
|
|||
|
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 :-( |
|
#5
|
|||
|
|||
|
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 :-( |
|
#6
|
|||
|
|||
|
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 :-( |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot chart format | Charts and Charting in Excel | |||
| Format Painter button problem | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| Text to Numeric format | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
