MacMost: MacMost Now

Learn to use header and footer rows in iWork Numbers. Footers allow you to easily perform functions, like sums and averages on entire columns. Headers can remain at the top of the screen as you scroll. Both can be used to keep calculations and titles separate from sorted data in the body of a spreadsheet.

iCloud services are tied into apps like Mail, iCal and Address Book. But you can also access your data through the iCloud.com web site. This allows you to get your email and access your events and contacts even when you are using a computer that doesn't have iCloud. The web-based apps are very sophisticated, offering almost the same functionality as the full apps, and often more functionality than the iOS apps. You can also use iCloud.com to transfer documents between your Mac and iOS devices, even in Lion.

Mac cleaning apps are being advertised heavily across the Internet. But do you need these programs? Some of what they do is already being done by OS X. And most of the rest is simply an effort to remove a small number of files from your drive and give you more drive space. But you can do better by archiving projects and keeping your documents tidy on your own.

Many people often wonder what export settings to use in iMovie in order to create the best DVDs. But DVDs are standard definition, and any video you export from iMovie will be re-encoded into a special DVD format. So it is merely a matter of exporting at the best settings available and then letting your DVD software use the best version of the video possible to create the DVD.

At the Worldwide Developer Conference Apple announced the next generation MacBook Pro complete with a retina display, the first Mac to get such a screen. In addition, Mountain Lion's release date was specified as this July, and iOS 6 for iPhones, the iPod touch and the iPad was announced. The new iOS will feature Facebook integration, a new Maps app and other new features.

If you are a recent switcher to Macs, you may be having trouble adjusting to the Apple keyboard and the way keyboard shortcuts work. Learn about the Command key and how to get to some basic keyboard shortcuts. Learn the Mac equivalents to how to change a file name, copy a file and Control+Alt+Delete.

After you have made many iMovie projects, you may want to remove them from your projects and events lists. This can be as easy as just moving the folders and files from your movies folder. If you want to go back to that project, simply move the files and folders back to their original locations.

While you may never need to go into your Mac's Library folders, it can be enlightening to know what they are used for and what is inside. This is where things like fonts, caches, preferences files and application support files are stored.

If you carry around USB flash drives, you may want to consider password protecting them in case they are lost or stolen. It is easy to format a drive with encryption using the OS X Disk Utility app.

Learn how to make playlists of your favorite songs and share them with friends. You can burn various types of CDs. You can also share your playlist online with friends using Ping, or gift a whole custom-made album of music to a friend.

Learn about the different hard drive formats like Mac OS, NTFS and FAT32. Find out how you can use NTFS drives with a Mac, and Mac OS drives using Windows. See how FAT32 formatted drives can be used to store files accessible to both systems.

With RSS reading functionality being removed from Safari and Mail in Mountain Lion, it is a good time to come up with an alternative. Google offers a free, easy-to-use and powerful RSS reader web site. It also works with several different apps so you can read your news on different devices and keep your data in sync.

If your carrier supports it, you can set up a personal hotspot with your iPhone so other devices like a MacBook or iPad can access the Internet. You can also connect with a dock cable or via Bluetooth.

One of the export options in iPhoto will let you export a set of photos as a web gallery, but not tied to any specific Internet service. You get a set a files that can be uploaded to your independent web host to your own site.

If you need to create printable forms that have blank spaces, you should use tab stops instead of underscore characters. Using tab stops allows you to line up blank spaces perfectly, making your forms look more professional.

Google Drive is a new cloud storage system that is tied into Google Docs and your Gmail account. It is similar to DropBox and also offers a reasonable amount of storage space for free. You can use it to sync documents between your Macs or simply keep backup copies. You can also share Google Drive files with others.

By setting a soundtrack to your Keynote presentation and then recording the presentation you can create a slideshow timed to music. You can use Keynote's special transitions and effects to make the slideshow interesting and unique. You can then export the presentation as a video.

Learn how to control which apps send you notifications and how they do it. You can choose how and where the notification appears, whether the app puts numbers in the icon or plays sounds. You can also arrange the order for notifications when viewed in the notifications center.

In OS X you have various ways of setting default applications for files and other actions. You can set your default email and web browser applications with settings in Mail and Safari. You can set what happens when you connect a camera or SD card, or insert an optical disc. You can also set which application will be used to open specific file types.

Learn about all of the different Safari browser preferences that affect security. You can find them in more places than just the Security tab. Learn what each one does to protect you while you surf online and decide what the best settings are for you.