Glenn Fleishman explains a tiny tweak you can make in Lion that enables AirDrop peer-to-peer file exchange to work over local area Ethernet and wireless networks. This enables AirDrop for older Macs that lack the right Wi-Fi chips to work with AirDrop out of the box, and it also adds wired LAN access for even those Macs that do have supported Wi-Fi chips. follow link
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.
Enable AirDrop for All Macs with Lion
Check out the Take Control ebooks that expand on the topic in this article: