Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-09-2016, 12:50 AM
Kokopelli's Avatar
Kokopelli Kokopelli is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Novice
How keep target text format when copying from other source?
 
Join Date: Oct 2016
Posts: 4
Kokopelli is on a distinguished road
Default How keep target text format when copying from other source?

When I have carefully created a table in an Excel 2010 and formatted each column just like I want it and then copy text from, say, an internet site, the formatting is changed to that of the source.



I use the <Ctrl-C>+<Ctrl-V> method as it is, to me, both quicker and more elegant. I know that were I to left-click in the cell, I would get the pasting options but for my needs that is too cumbersome and time-consuming.

Also, I have once found the correct setting years ago, and it worked pefectly for a long time - then my old machine conked out, I had to buy another one, reinstall Office 2010, only to find that I had forgotten how/where to find this setting.

I routinely, for a specific job that I do monthly, copy text of different formats, some words in the form of internet links, and then paste them into my carefully formatted spreadsheet.

This obviously wreaks havoc on my formatting and there is much work involved in setting things straight again - hardly a productive way to do it. Here's how it comes out now:



and here's how I would of course want it to be:



Like I say, I used to know how to do this so I know it is possible. Seems like it was somewhere in File/Options, I just can't find it.

Thank you.
Reply With Quote
  #2  
Old 10-11-2016, 09:24 AM
gebobs gebobs is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

There are lots of ways to skin that cat though they all boil down to doing a Paste Special of a sort...

* If you right-click on your destination cell, a context menu will appear with commonly used paste special options. You should use the one that looks like a clipboard with "123" on it, Values Only.

* Using only the keyboard, you can press CNTL-ALT-V, then V, and then Enter which is nice if you're a contortionist. A slightly less cumbersome keyboard method is Alt-H-V-V. I don't think there's a way to modify keyboard shortcuts as you can in Word which, not knowing the developers' minds on the matter, seems pretty lame.

* You can add a Quick Access Tollbar button for Paste Values.

* You can create a macro in your normal template (or the sheet you use if it's generally the same one) and assign whatever keyboard shortcut you want.

Personally, I use Paste Special all the time and I always use the first method.
Reply With Quote
  #3  
Old 10-11-2016, 10:43 AM
Kokopelli's Avatar
Kokopelli Kokopelli is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Novice
How keep target text format when copying from other source?
 
Join Date: Oct 2016
Posts: 4
Kokopelli is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
There are lots of ways to skin that cat though they all boil down to doing a Paste Special of a sort...

* If you right-click on your destination cell, a context menu will appear with commonly used paste special options. You should use the one that looks like a clipboard with "123" on it, Values Only.

* Using only the keyboard, you can press CNTL-ALT-V, then V, and then Enter which is nice if you're a contortionist. A slightly less cumbersome keyboard method is Alt-H-V-V. I don't think there's a way to modify keyboard shortcuts as you can in Word which, not knowing the developers' minds on the matter, seems pretty lame.

* You can add a Quick Access Tollbar button for Paste Values.

* You can create a macro in your normal template (or the sheet you use if it's generally the same one) and assign whatever keyboard shortcut you want.

Personally, I use Paste Special all the time and I always use the first method.
Thanks for answering gebobs. Yes, I shall have to use the first method in your list until such time as my memory returns, if it does. But as I said in the OP

'I once found the correct setting years ago, and it worked pefectly for a long time...' and 'I used to know how to do this so I know it is possible. Seems like it was somewhere in File/Options, I just can't find it.' and 'I (like to) use the <Ctrl-C>+<Ctrl-V> method as it is, to me, both quicker and more elegant. I know that were I to left-click in the cell, I would get the pasting options but for my needs that is too cumbersome and time-consuming.'

But it is my faulty memory and I will have to live with it...still, again thanks for taking time to answer.
Reply With Quote
  #4  
Old 10-11-2016, 11:10 AM
gebobs gebobs is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Yes, I read your post. I have no idea what it is you used to do or what in Options would accomplish what you need. Are you saying that in a previous version you could set CNTL-V to be Paste Text Only rather than a complete Paste?
Reply With Quote
  #5  
Old 10-11-2016, 11:20 AM
Kokopelli's Avatar
Kokopelli Kokopelli is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Novice
How keep target text format when copying from other source?
 
Join Date: Oct 2016
Posts: 4
Kokopelli is on a distinguished road
Smile

Quote:
Originally Posted by gebobs View Post
Yes, I read your post. I have no idea what it is you used to do or what in Options would accomplish what you need. Are you saying that in a previous version you could set CNTL-V to be Paste Text Only rather than a complete Paste?
Naw, it was Office 2010. I used Office 2003 for the longest time but none of the versions in between.
I stopped using that when I aquainted myself with the 2010 version and liked it; that was about 3 years ago.
(I am no Power User in case you couldn't tell ). Like I said, I do have a distinct memory of having once found a way to set this but have forgotten.
No biggie though. In the grand scheme of things this is a very, very small matter.
Thanks for following up though.

Last edited by Kokopelli; 10-11-2016 at 11:23 AM. Reason: Typo
Reply With Quote
  #6  
Old 10-11-2016, 11:39 AM
gebobs gebobs is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Kokopelli View Post
I do have a distinct memory of having once found a way to set this
I still don't know exactly what it is you are trying to set up? Are you trying to set a keyboard shortcut for Paste Text Only?
Reply With Quote
  #7  
Old 10-11-2016, 11:52 AM
Kokopelli's Avatar
Kokopelli Kokopelli is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Novice
How keep target text format when copying from other source?
 
Join Date: Oct 2016
Posts: 4
Kokopelli is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
I still don't know exactly what it is you are trying to set up? Are you trying to set a keyboard shortcut for Paste Text Only?
Oh, never mind. Let it rest. I can explain this to you (every detail is in the OP) but I cannot understand it for you. I'm sorry I posted in the first place.
Reply With Quote
  #8  
Old 10-11-2016, 12:43 PM
gebobs gebobs is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by Kokopelli View Post
Oh, never mind. Let it rest. I can explain this to you (every detail is in the OP) but I cannot understand it for you. I'm sorry I posted in the first place.
If you want me to help you, I am glad to do so, but I really don't appreciate the condescension.

If all the detail is in the OP, then I have missed it. I am trying my best to understand your issue and help you out as I have helped out hundreds of others just like you who are Excel neophytes and unfamiliar with the jargon to properly explain the issue.
Reply With Quote
  #9  
Old 10-11-2016, 11:34 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How keep target text format when copying from other source? Windows 7 64bit How keep target text format when copying from other source? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@kokopelli

Hello
please don't quote entire posts unnecessarily. They are just clutter and make the thread hard to read.
Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying and pasting text format paik1002 Excel 2 10-07-2016 02:34 AM
Hyperlink Format varies, depending on whether Target file was saved or unsaved on Hyperlink Copy RichardDavey Word 0 05-26-2015 05:26 PM
How keep target text format when copying from other source? cross-refs: navigate from target back to source eNGiNe Word 1 03-03-2015 12:51 PM
Insert space before and after target text Marrick13 Word VBA 6 06-20-2014 07:46 AM
Hyperlinks in an Includetext field do not work. Source and target on SharePoint witwabbit Word 2 11-06-2013 01:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft