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.
Back issues of the mailed edition of TidBITS
While all the articles in each mailed edition of TidBITS are available as individual articles, we also archive each edition in three forms (substitute an issue number for number):
- As an online issue at http://tidbits.com/issue/number
- As an HTML emailed issue at http://tidbits.com/static/html/TidBITS-number.html
- As a setext-formatted issue at http://tidbits.com/static/etx/TidBITS-number.etx
We didn’t plan to have two articles with “Zombie” in their titles this week, but that’s just how it worked out, as Matt Neuburg explains how you can prevent unwanted documents being reopened by Lion’s Resume feature, and Glenn Fleishman shares our experience dealing with server-crushing Web traffic generated by compromised computers. Also this week, Glenn looks at the Let’s Sing iOS app, Jeff Carlson reviews the Hammerhead Capo Case for the iPad, and Steve McCabe shares what it’s like to be able to test Facebook’s new “Highlight” feature in New Zealand. We also have two new Take Control ebooks: “Take Control of Your 802.11n AirPort Network, Third Edition” and “Take Control of iBooks Author.” Notable software releases during the last two weeks include QuarkXPress 9.3, OmniFocus 1.10.2, App Tamer 1.3, Fantastical 1.3, Typinator 5.1, Aperture 3.2.4, Coda 2.0, Cobook 1.0, Screenflow 3.0.6, and Keyboard Maestro 5.3.
We’re taking the next email issue off for the Memorial Day holiday, but we have an excellent slate of articles for you this week, including coverage of Apple’s security-related updates for Mac OS X 10.5 Leopard and the forthcoming demise of Perian, which provides QuickTime Player with support for many more video formats. Feature articles this week include Glenn Fleishman’s explanation of how you can use the free OpenDNS service to help protect your Mac from malware like Flashback, Tonya Engst’s look at how to deal with overly cluttered iOS Home screens, and Steve McCabe’s review of FileMaker Pro 12. Notable software releases this week include GraphicConverter 8.0 and TextWrangler 4.0.1.
Security news continues this week, with Apple releasing Mac OS X 10.7.4, Safari 5.1.7, and Security Update 2012-002, all largely to address security-related issues. Plus, Adobe fixes a security vulnerability in Photoshop, initially requiring a paid upgrade to Photoshop CS6 but later announcing that the fix would also be made available to users of Photoshop CS5.x. Moving to the practical, Joe Kissell explains how you can keep your MobileMe email address without upgrading to iCloud, and Adam Engst looks into what can happen if zooming is turned on accidentally in iOS and Mac OS X. Finally, Andy Affleck joins us with coverage of the genealogical program Reunion 10, and Joe shines a harsh light on Apple’s abundance of alerts. Notable software releases this week include Security Update 2012-002 (Snow Leopard), EasyFind 4.9, BBEdit 10.1.2, CloudPull 2.0.3 and 1.5.7, Microsoft Office 2011 14.2.2 and 2008 12.3.3, PDFpen and PDFpenPro 5.8.1, and Evernote 3.1.
What would you do if your Apple ID-backed accounts became inaccessible? That’s what Chris Owen ran into when Apple seemingly corrupted his account — read on for his entire story and think about how you’d work around such a problem. Also this week, Jeff Carlson covers iOS 5.1.1’s fixes quickly, and Glenn Fleishman looks at both Amazon’s weak Cloud Drive desktop app and the new connection between Tweetbot and Storify. Finally, Adam points to a new worldwide photography project that everyone can contribute to and describes a new internal tool that’s possible only because of Mac OS X’s inter-application communication. Notable software releases this week include Alfred 1.2, Transmit 4.1.9, SpamSieve 2.9.1, and Hazel 3.0.5.
We have a wide-ranging issue for you once again, starting with Apple’s stunning (if not surprising) $11.6 billion profit for Q2 2012 — Jeff Carlson runs down the details of where it all comes from. Continuing with Apple news, Adam covers the recent iTunes account security enhancement, which has caused no end of consternation for users. Glenn Fleishman looks the release of Airfoil Speakers Touch 3, which turns any iOS device into an AirPlay receiver, and the near-tandem releases of Google Drive and a major update to Microsoft’s SkyDrive, both of which are aiming at Dropbox. Lastly, Kirk McElhearn shares the story of French telecom provider Free, which has radically reduced the price of cell phone, Internet, TV, and landline connectivity in France. Notable software releases this week include Microsoft Office for Mac 2011 14.2.1, Pear Note 3.0, Carbon Copy Cloner 3.4.5, Send to Kindle for Mac 1.0, Firefox 12.0, PDFpen and PDFpenPro 5.8, and Bookle 1.0.5.
Security continues to weigh heavily on our minds, as Mark Anbinder encourages Java and Word updates to protect against the SabPub malware, and Glenn Fleishman explains how to report text message spam to AT&T. Glenn also reviews DropKey 1.0, a new utility for Mac OS X 10.7 Lion that simplifies exchanging encrypted files. In other news, Jeff Carlson notes Adobe’s just-announced Creative Suite 6 and the new Creative Cloud, a subscription service for using Adobe applications. And Instagram may be happy about being acquired by Facebook for $1 billion, but not all Instagram users are as excited, so Agen Schmitz looks at how you can back up your Instagram photo portfolio, in case you decide to jump ship. Lastly, Adam Engst delves deeply into Android to share the best ways — Amazon doesn’t make it easy! — to download and read EPUB and PDF ebooks on a Kindle Fire. Notable software releases this week include Quicksilver ß67, LaunchBar 5.2, and Suitcase Fusion 4.
One thousand one hundred and twenty-two issues of TidBITS can mean only one thing: it’s our 22nd birthday! To help us celebrate, would you consider becoming a TidBITS member so we can continue to do what we’ve done weekly for a score and two years: bring you important, interesting Mac and Apple news? The Flashback malware infestation tops our coverage this week: Glenn Fleishman and Rich Mogull dig into Apple’s critical Java updates that remove the Flashback malware, and Glenn works around an annoying related problem in Firefox. Also prompted by the Flashback problem, Jeff Carlson tells how he uses Dropbox to troubleshoot family members’ Macs. In non-malware news, Michael Cohen examines issues with making notes and using quotes in ebooks, and Steve McCabe gives in to Hype, a Mac utility for generating code for HTML5 animations and interactivity. Notable software releases this week include Acrobat X Pro and Adobe Reader X 10.1.3, Microsoft Office for Mac 2011 14.2.0, Final Cut Pro X 10.0.4, KeyCue 6.1, and TextWrangler 4.0.
In the news this week, we report on Dropbox doubling their referral bonuses — even retroactively! — and the notable release of FileMaker 12. Also, Adam looks in depth at the fast-moving Flashback malware, which has reportedly infected 600,000 Mac users, and he describes how to determine if you’re infected and how to avoid falling prey to Flashback. Continuing on the security kick, Rich Mogull explains just how the security of cloud-based services works and how you can tell if employees of your cloud provider can read your data. Notable software releases this week include TinkerTool 4.8, Hazel 3.0.4, SpamSieve 2.9, and App Tamer 1.2.1.
No April Fools issue this year, sorry! But we do share some of our favorite April Fools jokes, products, and services in case you were offline on Sunday. On the serious side, Adam explains how you can get up to 3 GB more storage space on Dropbox by beta testing the new Camera Upload feature, Jeff Carlson discusses how to use the PhotoSync app to transfer images back and forth between Macs and iOS devices, and Glenn Fleishman explains just why Apple’s strategy of making incremental changes to its products is confounding the rest of the technology industry. We’re also pleased to announce our latest ebook by Joe Kissell, “Take Control of CrashPlan Backups,” and, if you’re near New York City on 18 April 2012, invite you to come hear Adam and other industry figures talk about the Apple media world at MacTech Boot Camp New York. Notable software releases this week include Audio Hijack Pro 2.10.3, iPhoto ’11 9.2.3, Logic Pro 9.1.7 and Logic Express 9.1.7, iTunes 10.6.1, Airfoil 4.7, and Safari 5.1.5.
Apple’s third-generation iPad features strongly this week, as Adam reports on its impressive first-weekend sales, Sharon Zardetto explores selling her old iPad 2 to Amazon, and Matt Neuburg solves the mystery of why his books failed to transfer to iBooks on his new iPad. Matt also explains how you should hold your iPhone 4 or 4S for best performance with different types of calls, based on which of the phone’s two microphones will be used. For those who wish it were possible to sketch on paper and have the drawing automatically transferred to the Mac, Steve McCabe contributes a review of Wacom’s Inkling, an interesting device that is neither a graphics tablet nor a digital note-taker. And if you’re looking for an app to store your Inkling sketches, consider DEVONthink, coupled with Joe Kissell’s just-updated “Take Control of Getting Started with DEVONthink 2, Second Edition.” Notable software releases this week include CrashPlan and CrashPlan PRO 3.2, Skype 22.214.171.124, Keyboard Maestro 5.1, Fantastical 1.2.2, and Apple Software Installer Update 1.0.
We don’t focus on financial news much, but Adam found some fascinating details in Apple’s announcement that it would start using some of its cash to pay quarterly dividends and to repurchase stock. Other articles in this wide-ranging issue include Jeff Carlson’s explanation of how to use iTunes Match to get higher-quality, DRM-free copies of your music; Adam’s review of the CloudPull utility for backing up your Google Docs, Gmail, and other Google data locally; and Glenn Fleishman’s analysis of a recent Elcomsoft white paper criticizing the security of iOS password-keeping apps. Finally, we’re pleased to welcome as a long-term sponsor Fujitsu, makers of the ScanSnap family of document scanners. Notable software releases this week include Aperture 3.2.3, Sandvox 2.5.3, and Firefox 11.0.
Apple news once again drives our coverage, with Apple’s announcement last week of the third-generation iPad, the third-generation Apple TV, iOS 5.1, iPhoto for iOS, and various updated iOS apps. Less emphasized was Apple’s cancellation of iWork.com, a stillborn collaboration service that never made it out of beta. In other news, Intuit has released Quicken Mac 2007 Lion Compatible, and we’re pleased to bring you our latest ebook, “Take Control of BBEdit.” Finally, Adam takes you on a hypertextual tour of some delightfully interconnected blog posts about how big media companies suffer from unauthorized copying largely because they’re not meeting the needs of their customers. Notable software releases this week include Safari 5.1.4; iTunes 10.6; iBooks Author 1.1; GarageBand ’11 6.0.5; iPhoto ’11 9.2.2; DEVONagent Lite, Express, and Pro 3.1.2; Adobe Lightroom 4.0; and Parallels Desktop 7.0.15055.
We’re busy preparing for Apple’s iPad announcement on Wednesday, but we have some great articles for you to read in the meantime. Adam leads with a look at how AT&T is now throttling unlimited plan users (their bandwidth, not them personally) when they hit 3 GB of usage and how affected users might be able to fight back. Then Jeff Carlson reviews Reflection, a Mac OS X application that acts as an AirPlay receiver, so you can mirror your iPad 2 or iPhone 4S display on the Mac, which is a boon to speakers, educators, and anyone who needs to demo iOS apps to a group. Finally, we look into Apple’s twice-delayed requirement that apps in the Mac App Store be sandboxed to see how it impacts developers and users alike. Notable software releases this week include Mac OS X 10.7.3 Supplemental Update; Hazel 3.0; GraphicConverter 7.6.2; DEVONthink Personal, Pro, and Pro Office 2.3.3; Firmware Update for MacBook Pro (15-inch, late 2008 models); HandBrake 0.9.6; Fetch 5.7.1; TextExpander 3.4.1; and iMac Wi-Fi Update 1.0.
In the category of articles we hate to have to write, Adam leads off this week’s issue with a detailed look at the Flashback malware, which has morphed from masquerading as a Flash Player installer to exploiting Java vulnerabilities and suckering users with a fake self-signed certificate prompt. For the rest of the issue, put your feet up and read along with Michael Cohen as he shares his story of getting Find My Mac to work, and with Steve McCabe as he ponders how best to replace a dying iMac — it’s an interesting thought experiment to imagine how you might solve a similar problem. Notable software releases this week include iMac Wi-Fi Update 1.0; Firmware Updates for iMac, Mac mini, MacBook Air, and MacBook Pro; ScreenFlow 3.0.5; Camino 2.1.1; and PDFpen and PDFpenPro 5.7.2.
The big news this week — and nearly our entire issue — revolves around OS X 10.8 Mountain Lion, which Apple has released in developer preview form. Rich Mogull, who was briefed early by Apple due to his position in the Macintosh security world, explains what’s new and interesting about Mountain Lion and then goes into more depth about Gatekeeper, the new security technology in Mountain Lion that promises to eliminate the possibility of a malware epidemic. For those still living in the present, Adam explains how he tracked down and eliminated a troubling performance problem in 10.7 Lion. Notable software releases this week include Default Folder X 4.4.9, VLC 2.0, Bookle 1.0.4, and Airfoil 4.6.5.
Finally, a breather from non-stop breaking news! This week we step back a bit to share some useful evergreen content from a variety of contributors. Glenn Fleishman leads with a short article pointing to a 15-minute screencast he has created to walk users through the new AirPort Utility 6.0, and Marshall Clow joins us with a review of the improbably named iSesamo (it’s a spudger, and if that doesn’t help, you’ll really have to read the article). While trudging through an hour-long installation process to get a Fujitsu ScanSnap scanner working, Michael Cohen points out that hardware companies need to devote just as much attention to their software. Steve McCabe contributes a look at FileMaker Go for the iPhone, which lets you use FileMaker Pro databases while out and about. Finally, Tonya anchors the issue with a detailed look at some of the real-world strategies she has developed for switching from Microsoft Word to Apple’s Pages. Notable software releases this week include Bookle 1.0.3; Piezo 1.1.2; Firmware Updates for iMac, MacBook Pro, and MacBook Air; Carbon Copy Cloner 3.4.4; and ChronoSync 4.3 and ChronoAgent 1.3.
We have two big pieces of our own news this week: the release of the Bookle EPUB reader for Mac OS X and a 50-percent-off Take Control sale to celebrate. Apple’s news isn’t as good — last week’s release of Mac OS X 10.7.3 and Security Update 2012-001 for Snow Leopard were both marred by significant problems; Apple had to update the security update and pull the delta updater for 10.7.3. More interesting was the release of AirPort Utility 6.0, which provides a whizzy new graphical view of your wireless network, but removes advanced features from the previous version — wireless expert Glenn Fleishman has all the details. Glenn also continues our Macworld | iWorld coverage with a piece about using Find My Friends and a list of our video appearances at the show. Notable software releases this week include Audio Hijack Pro 2.10.1, Sandvox 2.5, Firefox 10.0, and Final Cut Pro X 10.0.3.
We’re back from Macworld | iWorld with oodles of coverage for your enjoyment. Adam provides an overview of what the show was like, Jeff Carlson focuses on iOS-related photo and video highlights, Glenn ponders the preponderance of booth babes, and we all contribute to a lengthy list of cool products we saw at the show. Also this week, Michael Cohen reports on Apple’s Q1 2012 financial results, which were surprisingly strong, even for Apple. Notable software releases this week include firmware updates for the Mac mini, MacBook, and 13-inch MacBook Pro; PDFpen and PDFpenPro 5.7; Fantastical 1.2; Yojimbo 3.0.3; and BusyCal 1.6.2.
Apple’s special event last week may have been targeted at the education market, but the new iBooks 2, iBooks Author, and iTunes U apps — and how they’re being seen by both those who create books and those who read them — dominate this week’s issue of TidBITS. Adam covers the basics of Apple’s announcements, and also looks at why much of the consternation is happening because people are missing that Apple is aiming everything at the education market. Michael Cohen also weighs in with commentary about why iBooks Author will be a big deal in education, but taking the opposite view is physics teacher Steve McCabe, who argues that iBooks textbooks offer a warmed-up take on twenty-year-old ideas. In our own publishing news, it may not be an enhanced iBooks textbook, but Glenn Fleishman’s new “Take Control of Screen Sharing in Lion” still has all the help you need to choose and use the right method of screen sharing for your needs. And speaking of Glenn, he also runs down the latest changes in AT&T’s data plans for iPhones and iPads. Notable software releases this week include iTunes 10.5.3, Typinator 5, QuarkXPress 9.2, and Default Folder X 4.4.8.
We’re getting ready for next week’s Macworld Expo, er… Macworld | iWorld, so if you’re going, be sure to check out the TidBITS Events list for where we’ll be. In other news this week, Adam weighs in on the SOPA/PIPA issue with a perspective that hasn’t seen much play — that of what it’s like to be a small publisher whose work is used without permission. Adam also reviews Third Rail Mobility’s Slim Case System (a battery-powered case for the iPhone 4 and 4S), and Glenn Fleishman proposes some fixes for preventing unexpected sounds from iPhones during performances. Also, our latest ebook is Kirk McElhearn’s “Take Control of iTunes 10: The FAQ, Second Edition!” Notable software releases this week include GraphicConverter X 7.6, BBEdit 10.1.1, and the Adobe Photoshop Lightroom 4 Public Beta.
With little happening in the way of actual news this week, we focus on the practical, leading off with Adam’s examination of Lumin, a simple iOS app that turns your iPhone into an illuminated magnifier. Then Michael Cohen looks at Snapseed, a photo-enhancement app that displays some innovative interface techniques. Moving into the Mac and networking worlds, guest contributor Marshall Clow explains how to set up a simple blog with the Markdown- and Dropbox-driven service Calepin, and Matt Neuburg shares how he used iTunes Match to gain access to a subset of his music on all his devices.
Happy New Year! There was a surprising amount of news over the holiday break, and Glenn Fleishman was quick off the mark to cover Intuit’s plans to release a Lion-compatible version of Quicken 2007, GadgetTrak’s new CameraTrace service for tracing stolen cameras, LogMeIn’s new remote-access app for iOS, GoDaddy’s dropping of support for the Stop Online Piracy Act, and Apple’s addition of a “Complete My Season” option for iTunes Store-purchased TV shows. Glenn also collected the top 10 most-read TidBITS stories of 2011, Adam followed up on the success of our TidBITS membership program and wrote the most popular story of the year about Google’s “Let It Snow” Easter egg, and Michael Cohen tracked down how iCloud’s Photo Stream interacts with multiple iPhoto libraries. Notable software releases since our last issue include Piezo 1.1 and iTunes 10.5.2.
We need your help! Become a TidBITS member today and help keep TidBITS going! Details about our new TidBITS membership program are in this issue, along with Adam’s instructions for getting Snow Leopard’s iCal to talk with iCloud and his review of Rogue Amoeba’s new Piezo audio recording app for the Mac. You’ll also find Tonya’s look at what’s new in iBooks 1.5 for iOS and Mark Anbinder’s coverage of the new version of the TweetDeck Twitter client, which no longer relies on Adobe AIR. Notable software releases this week include SOHO Labels 6, Aperture 3.2.2, TextExpander 3.4, and Keynote 5.1.1. Finally, note that this is our final email issue of TidBITS for 2011; look for your next issue on 2 January 2012, and in the meantime, our best wishes for a relaxing holiday break!
We find ourselves in the middle of a pair of controversies this week. First, an iPhone app that promises (and delivers) tethering for a one-time $14.99 fee is approved in the App Store and becomes an instant hit, but Apple quickly pulls it, citing a weak excuse. And then there’s the hullabaloo about Siri supposedly toeing an anti-abortion line with responses to particular queries; Adam explains why it’s unreasonable to attribute Apple corporate policy to anything Siri says. Also this week, Jeff Carlson looks at several iOS apps that work by listening to the world outside, and Adam shares his surprisingly smooth experience getting his iCloud calendars to sync with Macs that can’t run Lion, thanks to BusyCal. Finally, we’re pleased to announce not one, but two new ebooks covering iOS 5: Tonya Engst’s “Take Control of Your iPad” and Joe Kissell’s “Take Control of Mail on the iPad, iPhone, and iPod touch, Third Edition.” Notable software releases this week include Cyberduck 4.2, MarsEdit 3.4.1, Camino 2.1, and Safari 5.1.2.
If you’re worrying about what will happen to your photos in MobileMe Gallery come June 2012, there’s a new migration option — to the photo sharing site ZangZing that Adam has been using heavily. Also this week, Matt Neuburg explains Appalicious’s morphing into Appcuity in time for finding Mac App Store deals during the holiday shopping season, and Glenn Fleishman looks at how Amazon’s Kindle Fire provides a more coherent interface for finding and playing purchased media than Apple’s iOS apps. Finally, Adam explains how the Children’s Online Privacy Protection Act of 1998 is teaching children to lie about their ages online, often with the help of their parents. Notable software releases this week include Nisus Writer Pro 2.0.2 and Nisus Writer Express 3.4.1, VMware Fusion 4.1.1, SpamSieve 2.8.8, and MacBook Pro Video Update 1.0 (Snow Leopard).