Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kirstie
 
Posts: n/a
Default how do I drag & drop cell text only

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.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
mudraker
 
Posts: n/a
Default how do I drag & drop cell text only


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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
Ragdyer
 
Posts: n/a
Default how do I drag & drop cell text only

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" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? PaulH_1980 Excel Worksheet Functions 1 March 15th 06 11:51 PM
HOW TO KEEP TEXT FROM MOVING OUT OF A CELL? Briguyy Excel Discussion (Misc queries) 2 February 23rd 06 09:04 PM
Can you keep text from one cell showing over the next cell? Sean VandeWall Excel Discussion (Misc queries) 2 February 22nd 06 08:20 PM
HOW DO I DRAG AND DROP W/O TAKING CELL BORDER? don perkins Excel Worksheet Functions 1 January 13th 06 01:05 AM
How do I set text to top of cell next to wrap text in Excel? Carpenter Gary New Users to Excel 1 October 25th 05 06:26 PM


All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"