For this week’s Roundup: how to put zeroes in otherwise blank cells in Excel (and not the long way, either), how to pick and choose which formatting marks Word shows you with Show/Hide, and a heads-up on some hefty discounts on several Outlook plug-ins.
Paste Special
One of the tactics I regularly recommend to users when transferring content from an old WordPerfect document is to use Paste, Special, Unformatted Text instead of just the plain Paste or CNTRL-V commands:
The advantage here is that Paste Special clears out all of the formatting so the newly-pasted text doesn’t mess up your nice Microsoft Word document.
The disadvantage? Well … it clears out all the formatting. And this can be a pain to re-do, particularly if you’ve got a long document with lots of case citations, etc.
What to do? Here are three tricks to keep in your Microsoft Word skills arsenal.
We’ve all done it — there’s already a WordPerfect document that you need some text out of (a letter addressee, a section out of a brief, whatever), so you decide to cut-and-paste from WordPerfect into your current Word document.
And the formatting in your Word document goes totally … WAAAAAAHHHH!
Here’s how to avoid that:
Connect with The Guru!