Try dragging with the *right* mouse button.
When you release it, you are presented a choice of copy, formats, or values.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kirstie" <(E-Mail Removed)> wrote in message
news

7C4A321-861F-4157-9F64-(E-Mail Removed)...
> I have text information in cells which I want to be able to drag and drop
to
> other cells, but I do not want to drag and drop the borders from the
cells.