PC Review


Reply
Thread Tools Rate Thread

how do I drag & drop cell text only

 
 
=?Utf-8?B?S2lyc3RpZQ==?=
Guest
Posts: n/a
 
      9th May 2006
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.
 
Reply With Quote
 
 
 
 
mudraker
Guest
Posts: n/a
 
      9th May 2006

Kirstie

Dragging & Dropping copies everything - text, formating, formulas etc

You would need to use Copy & PasteSpecial


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=540219

 
Reply With Quote
 
Ragdyer
Guest
Posts: n/a
 
      11th May 2006
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
news7C4A321-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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drag and drop text in userform text / combo boxes Roger on Excel Microsoft Excel Programming 1 22nd Nov 2009 11:34 AM
Cell drag and drop clara Microsoft Excel Misc 4 18th Jun 2008 07:36 PM
cell drop and drag =?Utf-8?B?RCBTbmlkZXI=?= Microsoft Excel Worksheet Functions 1 1st May 2005 04:27 AM
drag and drop of table cell...... Cheryl Microsoft ASP .NET 1 20th Oct 2004 07:19 PM
Cell Drag & Drop without Incrementing Paul Microsoft Excel Misc 3 2nd Apr 2004 02:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:50 PM.