Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling Take Control ebooks.

 

 

Pick an apple! 
 
Copy Excel Selection as a Picture

Want to show someone a chunk of an Excel spreadsheet via email or iChat? You could take a screenshot, but if you want to show just a portion of the Excel window and you don't use a utility like Snapz Pro, you can do this right from within Excel 2008. Make a selection, hold down the Shift key, and choose Copy Picture from the Edit menu. You can select whether the selection will be rendered as though it was shown on screen or as though it was printed. Then just switch to your desired destination and paste.

 

 

Related Articles

 

 

Updated Paste Plain Text AppleScript for Word 2008

Send Article to a Friend

In "Word 2008 and the Paste Plain Text Dance" (2008-01-19), I described a tiny AppleScript I use in Word 2008 to paste text without style information, so that the pasted text adopts the style of whatever is around it. From the feedback I've received, the lack of a built-in command to do this with one click had irritated quite a few people. Since then, I've found that very occasionally - I can't quite discern a pattern to why or when - text pasted with my script takes on the default font of Word's Normal template (Cambria), rather than the actual font of the surrounding text.

So I experimented further, and I've come up with a revised script that not only solves this problem but takes an entirely different approach that results in a shorter and more elegant solution. Thus far I haven't seen any occasions in which the new script fails. As before, you can either paste this into Script Editor or download the completed script, unzip it, and put it in ~/Documents/Microsoft User Data/Word Script Menu Items. Here's the script:

tell application "Microsoft Word"
    tell selection
        try
            set theClip to Unicode text of (the clipboard as record)
            type text text theClip
        end try
    end tell
end tell

Now, instead of counting the number of characters on the clipboard and moving the insertion point, the script uses the "type text" command to simulate typing, which automatically puts the insertion point in the right place.

 

READERS LIKE YOU! Support TidBITS by becoming a member today!
Check out the perks at <http://tidbits.com/member_benefits.html>
Special thanks to Mario S. De Pillis, Sr., glo-arc, Denis Jarvis, and
William Stanley for their generous support!