MacMost: Archives

There are many options for formatting cells in iWork Numbers. You can choose the number of decimal places, or use fractions. You can format as currency or choose a different base system. You can choose from a variety of date and time formats. You can also create steppers, sliders and pop-up menus to make it easy to change values to cells. Conditional formatting allows you to have cells that change color and style with certain values or ranges.

When you sync photos from your computer to your iPhone you will get an album named Photo Library in your Photos app. This isn't an album, but a complete list of all of the synced photos on your iPhone. It will include those in albums and events you have synced, but the photos are really only on your iPhone once. The Photo Library is just a way to view of list of all of these photos instead of viewing them by album or event.

Learn how to use keyframes to animate video in Final Cut Pro X. You can scale and reposition video clips between keyframes to create a variety of special effects. The example used is video shrinking to the center and then moving to a corner. You can also use keyframe animation to rotate, distort, color adjust or fade a clip.

You can control a Keynote presentation on a Mac with your iPhone, iPod touch or iPad using the Keynote Remote app. But this requires that both the Mac and iOS device be on the same wi-fi network. In cases where you don't have a wi-fi network, such as a presentation hall or classroom, you can establish your own local network using your Mac, and connect to it with your iOS device. This allows you to control the Keynote presentation directly from your device to the Mac.

In your Mac's Applications folder you've got a Calculator app that you probably haven't given a second look. This is much more than a simple utility. You can use it in scientific and programmer mode, convert units, time and currency, work in octal and hexadecimal, produce a tape of your calculations, and even get it to talk to you.

Learn how to add keyboard shortcuts to your iPhone, iPod touch and iPad. Keyboard shortcuts can make it much easier to type using the on-screen keyboard. You can substitute short groups of letters for longer phrases, like 'em' for your email address or 'icu' for 'I'll call you later.'

Keeping your Address Book contacts in a good state is even more important now because of integration with iCloud, iOS 5 and social networks. There are several fields in Address Book that are more than just bare information. Learn the special properties of the birthday, nickname, phonetics and URL fields.

While Siri has brought speech commands to the iPhone 4S, Mac users have long had the ability to speak commands to your computers. Learn how to enable Speakable Items on your Mac, find out which commands work and how. You can also add custom commands and have your Mac speak to you.

iOS 5 for the iPhone, iPod Touch and iPad has a great set of accessibility features that can be useful for just about anyone. You can zoom in on the screen, change the font size for some apps, have your iPhone speak text on web pages and in documents, use multi-touch gestures with just one finger, and even set custom vibration sequences.

Reminders are calendar events that can be used as to-do items or alerts. They sync between your Macs and iOS devices. They can also be set as location-based alerts on the iPhone. You can use Siri to create new reminders on the iPhone 4S.