Working between Excel and Word Thread poster: Christopher W Gladden
|
Hi, I have a fairly big project that the client has all laid out in Excel, which I find very cumbersome as a word processing tool. So I was going to just copy and paste between Excel and Word. The problem is that when I paste back into Excel, all formatting is immediately lost (the paste options dialogue doesn't even open). My system's on Word 2016, and their version of Excel is a bit older... don't know if that's involved. Anyway, I don't necessarily HAVE to use Word, but I'd reall... See more Hi, I have a fairly big project that the client has all laid out in Excel, which I find very cumbersome as a word processing tool. So I was going to just copy and paste between Excel and Word. The problem is that when I paste back into Excel, all formatting is immediately lost (the paste options dialogue doesn't even open). My system's on Word 2016, and their version of Excel is a bit older... don't know if that's involved. Anyway, I don't necessarily HAVE to use Word, but I'd really like a way to work and this project making the formatting changes I need to while NOT doing it directly in Excel. Any suggestions? Thank you! Chris ▲ Collapse | | | esperantisto Local time: 03:31 Member (2006) English to Russian + ... SITE LOCALIZER Paste special? | Aug 29, 2016 |
Try using Paste special (select it from the dropdown menu on the Paste button, it’s for Office 2010, don’t know about the 2016). | | |
You have probably considered using a CAT tool, yet I wanted to point it out. | | | Emma Goldsmith Spain Local time: 01:31 Member (2004) Spanish to English Cat tool seconded | Aug 29, 2016 |
Elif Baykara wrote: You have probably considered using a CAT tool, yet I wanted to point it out. Need a like button! | |
|
|
Tony M France Local time: 01:31 Member French to English + ... SITE LOCALIZER What formatting issues? | Aug 29, 2016 |
Christopher W Gladden wrote: ...when I paste back into Excel, all formatting is immediately lost (the paste options dialogue doesn't even open). Could you be more specific? Exactly WHICH formatting attributes are lost? I'm still using a much odler version of Word / Excel, so I've never experienced this problem. However, there is one very well known issue which has a simple solution: when pasting back from Word into Excel, any manual line returns (NOT ¶!) create suprious extra cells; on a large spreadsheet, this can look alarming! However, it is easy enough in Word to 'replace all' such line breaks with some unique character combination, and then once safel back in Excel, do the reverse search-&-replace to restore them. Could this be the main part of your problem, as you don't say exactly what 'formatting' is giving you the headache? | | |
Hi, I should have been more specific. I'm not translating directly in Word. The formatting involves colored text that the client wants and doing it in Word should be pretty smooth (SHOULD be (hahaha)). Thank you for all your feedback! Much appreciated. | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Working between Excel and Word Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
| TM-Town | Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |