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: 18:43
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: 17:43
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: 17:43
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 | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
| | Anycount & Translation Office 3000 | Translation Office 3000
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
