Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How keep target text format when copying from other source?

08 Oct 2016   #1
Admiral Awesome

Windows 7 Pro 64-bit
How keep target text format when copying from other source?

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

whereas I of course want to keep the table formatting:

How do I keep the table/target text format when pasting using Ctrl+V? I used to know how, but forgot, so
I know it can be done (in a not-so-obvious Excel setting) w/o creating macros and using complex key-combinations.

Thank you.

My System SpecsSystem Spec
08 Oct 2016   #2

Windows 7 Home Premium 64 bit sp1

I assume you are using the Copy & Paste method for inserting the text from the internet.

I am using Excel 2013, but I think it performs the same way as Excel 2010. Although I don't copy & paste text from the internet I do a lot of copying & pasting in Excel. When I click on the insertion point that I want the copied text to start in Excel, I Right Click & that will list a selection of Paste options. I use this method rather that the keyboard Cntrl-C & the Cntrl-V, which does not provide any paste options.

You will need to try the various paste options to see which one works the best for you.
My System SpecsSystem Spec
09 Oct 2016   #3
Admiral Awesome

Windows 7 Pro 64-bit

Thanks Ranger4, you assume correctly. Fabulous! (oh, that was what I said in the OP "...text from, say, an internet site..." sorry).

"...Although I don't copy & paste text from the internet I do a lot of copying & pasting in Excel/.../I Right Click & that will list a selection of Paste options..."

Well, that's the easiest thing imaginable, I can do that too, obviously. But to me the <Ctrl+C>+<Ctrl+V> way is quicker as well as more elegant. Like I said I used to know how to do this, i.e. there is a way in Excel 2010 to set this permanently, but I forgot how.

It'll come to me though. Like, thx anyway.
My System SpecsSystem Spec

18 Nov 2016   #4


There is difference between coping from Internet and coping from other MS Word file. If you coping from same format and same version of MS Word, then there should be no problem. But while coping text from internet, you can observe these errors frequently.
My System SpecsSystem Spec
18 Nov 2016   #5

Windows 7 x64

There is this way i was using without any problem.

Do a template.

1. Design your template on a new worksheet.

2. The template should include all sort of formatting, fonts, etc.

3. Save to a location commonly use, else you may forgot the location.

4. Download the source. Do remember that the template column & rows are identical between the source and template.

5. Once download and save.

6. Open the template workbook or worksheet, whichever.

7. Copy and paste the template on to the source.

8. Save it.


If you have done your design template properly, you can test with the original source.

It is best to create the design template on the original source.
After completed the template, then remove the numbers & words.
In this way, your template will be accurately formatted accordingly.

Should there be an error, do review your template and the original source which use for the design.

Sometimes, the source may change a bit, hence you need to check for any entries being changed.

I would recommend to use Access, if the data is >10,000 rows &or items.

For Access, you can do use Pivot Tables to Excel, plus an options to include all the items or not.

Pivot table best is for large quantity.
My System SpecsSystem Spec

 How keep target text format when copying from other source?

Thread Tools

Similar help and support threads
Thread Forum
copying text in Word 07 creates bookmarks??
Suddenly, whenever I copy anything in Word 07, the copied text is bracketed with square brackets. They are gray color, and they are not reflected in the clipboard contents, so I believe they are non-printing characters. I have never had this happen before, and can't figure out what is going on....
Microsoft Office
OneNote OCR issue - not copying original format of text
I am a beginner user to Microsoft's OneNote, and hence just discovered their OCR 'grab text from image' handy feature. However, when I do this, it does not keep the original paragraph format of the text. For instance, if the text is: Lorem ipsum dolor sit amet, consectetur adipiscing elit....
Microsoft Office
Robocopy /MOV command copying but not deleting from source directory
Hi All, I have one folder A and have another folder B in the same drive E: I need to move all the content from folder A which are more than 2 years old to folder B. Hence when I ran the robocopy it just copied and I lost all disk space in drive E. My question is even though I used /MOV...
General Discussion
frequent bsod when copying certain text
Ive included the output files in this post my os is windows 7 home premium oem. the problem has occured even after a restore it is a asus x52j notebook, it is less than 6 months old and the hard drive has one bad sector The type of text i get the bsod from is like:
BSOD Help and Support
Copying Files Within Source Folder
This is something small, but kinda annoying for me. In XP, if I copied and pasted a file within the same folder, the file name would be "copy of file.ext". this was great for me cause I could easily sort the files by name and then move them to the final destination folder. But now in Win7, the...
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 20:03.
Twitter Facebook