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.
Written by
Adam C. Engst
Recent TidBITS Talk Discussions
- TurboTax 2009 (2 messages)
- Aussie iTunes rip-off (17 messages)
- Activity Monitor mystery (1 message)
- How to copy contents of Address Book card to clipboard? (1 message)
Published in TidBITS 969.
Subscribe to our weekly email edition.
- 3rd Generation iPod shuffle Shrinks, Gets Mouthy
- iTunes 8.1 Enhances DJ Capabilities
- App Store Reviews Now Distinguish Versions
- Printing Shipping Labels from PayPal's Shopping Cart
- A Silly Saga: How I Downloaded an Audio Book from My Library
- TidBITS Watchlist: Notable Software Updates for 16-Mar-09
- ExtraBITS for 16-Mar-09
- Hot Topics in TidBITS Talk for 16-Mar-09
In Search of iTunes 8.1's Autofill
The recently released iTunes 8.1 makes Autofill available to all iPods, instead of just the iPod shuffle. Autofill makes filling your iPod with music easy, automatically selecting the amount of music that will fit so you don't have to guess. While Autofill performs this task beautifully, it's not at all obvious how to gain access to the feature for your iPod (or iPhone).
Here are the steps you must follow to take advantage of Autofill in iTunes 8.1:
- Connect your iPod to your computer.
- In the iTunes source list (that's the sidebar on the left), click the icon of your iPod.
- At the top of the main iTunes pane, click the Summary tab.
- Near the bottom of the Summary info pane, enable the "Manually manage music and videos" checkbox.
- Return to the source list, click the triangle to the left of your iPod to reveal its contents, and then click the Music icon below it.
And there you have it: at the bottom of the iTunes window, a new pane appears with an Autofill button, a Settings button, and a menu from which you can choose a source for the Autofill operation.
Easy as pi - if you calculate pi on an abacus (which you may have found yourself with the inexplicable urge to do last Saturday, National Pi Day). Seriously, while the Autofill feature is most welcome, the method by which you access it is serpentine. Here are some things Apple should consider if they want to improve the user experience:
- Don't require five steps to get access to an "ease of use" feature; that's four more steps than is necessary.
- Don't make the user click through three screens of iTunes Help to get to the Autofill instructions.
- Don't require the user to set something to "manual" in order to access an "auto" feature.
- Don't make the user click a Settings button just to see the feature's current settings: there's plenty of room in the Autofill pane to display them.
- Don't make the feature's settings ambiguous. For example, does "Replace all items when Autofilling" also mean photos will be replaced? What about TV shows? Podcasts?
Why do I get the feeling that this pie is not completely baked? Hopefully, Apple will take some of my advice and make it easier to access this otherwise handy feature.
[Being the author of "Take Control of Syncing Data in Leopard," Michael E. Cohen cares very deeply about all topics related to synchronization.]



