Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drag value not format?!
Hello all,
I am working on a spreadsheet task and a case arises when a user selects a cell(or some cells) then drag the fill handle to copy data or fill adjacent cells with a series of data. However it causes the orignal cell/s' formatting will be copied to the destination cell/s too, i.e. the conditional formatting previous imposed on the destination block will be overwritten by the origin's. Is there any way to allow for only value copying but NOT formatting so any existing conditional formating will be able to survive? Thanks in advance and have a wicked Easter! Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drag down | Excel Worksheet Functions | |||
Fill & Drag to Right !! HELP ! | Excel Discussion (Misc queries) | |||
Can I fix a format so it doesn't change when I drag or copy/paste | Excel Worksheet Functions | |||
drag..... | Excel Discussion (Misc queries) | |||
drag value not format | Excel Discussion (Misc queries) |