Working between Excel and Word Tópico cartaz: 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: 10:14
Membro (2006)
inglês para russo
+ ...
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
Espanha
Local time: 09:14
Membro (2004)
espanhol para inglês
| 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
França
Local time: 09:14
Membro
francês para inglês
+ ...
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 » |
| | 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... | | | | | |
Login to reply/comment 
