pasting highlighted text from Word to Excel and back

[karlhar]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am trying to paste text in Word into Excel - and back again - and retain the text highlighting from Word. Excel won't pick up the highlighting at all from Word. And Excel insists on highlighting entire cells and not individual letters if try highlighting characters there. Is there a way to do this? I suspect maybe not ...

If not, I have a large document with various colored highlighting I need to do some stuff to in Excel - and then put back in Word. Is there a way to retain the highlighting effect in a different form - such as converting the highlighting to colored fonts - which can be transfered back and forth?

Thanks,
- Steve

 

[CyberTaz]

If by "highlighting" you mean as applied by the use of the Highlight Tool in
Word, then no. That feature isn't supported in Excel & it isn't an attribute
of the text so the Highlight color will not be retained. Font color will.

You can use Find in Word to locate Highlighted content but not on a
color-specific basis. Click the chiclet button in the Find dialog to expand
it, then click "Format' & select Highlight. Change the font color as you
work through the document using Find Next. (Use the 'Browse by' buttons at
the bottom of the Vertical Scroll Bar.)

HTH |:>)
Bob Jones
[MVP] Office:Mac