Stop Eye Strain in Excel 2008
You can make text bigger in Excel by zooming to a larger percentage with the Zoom control in the toolbar, or by selecting the cells containing too-small text, choosing Format > Cells (Command-1), and then setting options in the Font pane. You can also increase the default font size for new sheets by modifying the Size field (next to the Standard Font field) in the General pane of Excel's preferences.
Series: Palm Desktop 2.1
Palm Computing breathes life into the PIM formerly known as Claris Organizer
Article 1 of 2 in series
by Jeff Carlson
A few years ago, I realized it was time to abandon my tangled mess of scribbled and photocopied papers that formed my personal information management (PIM) systemShow full article
A few years ago, I realized it was time to abandon my tangled mess of scribbled and photocopied papers that formed my personal information management (PIM) system. I had tried using Now Contact and Now Up-to-Date, but never developed the same enthusiasm about them as many of my friends. Then I discovered Claris Organizer: it had a sharp interface, combined addresses with a calendar and to-do list, and printed the information on sheets that fit the small three-ring binder I used as a poor-man's Day-Timer. For a while, I was a happy, more organized man.
When I decided to buy a PalmPilot, where I could store the same information in a pocket-sized handheld device, I faced the same dilemma as all Macintosh-using PalmPilot owners: the device worked with either Pilot Desktop 1.0, an ugly Windows port, or Now Contact/Up-to-Date, using the buggy Now Sync. I briefly entertained romantic notions of learning AppleScript to somehow share the Pilot Desktop information, but reality intruded and I abandoned Claris Organizer.
Until now. Although Pilot Desktop never advanced beyond version 1.0, a funny thing happened in Cupertino. In the middle of last year, after Apple reabsorbed Claris and killed everything but FileMaker and ClarisWorks (now AppleWorks), Organizer was sold to Palm Computing. Not only was an improved Macintosh Palm desktop application on its way, it was going to be based on my old favorite! After long months of waiting, Macintosh Palm Desktop 2.1 has been released. Not only can most Mac owners of Palm handhelds take advantage of a modern PIM that synchronizes easily with their Palm data, but Organizer users have the assurance that their Claris software continues to survive (something Emailer users still can't claim).
A Good Price for Everyone -- The Palm Desktop software is available now as a free download from Palm's Web site (with additional server support from Apple) in three binhexed portions: the Palm MacPac v2 Installer (12.6 MB), Documentation (2 MB), and Palm Extras (24.3 MB). You only need the MacPac Installer to use the software, but there are plenty of goodies in the Palm Extras to warrant the lengthy download (see below).
Palm has decided to offer the software free to any takers, whether you own a Palm device or not. The only restriction is that Palm will provide support only to users with a valid serial number from the back of a Palm handheld. Obviously, they would prefer that users support them financially by purchasing Palm devices, but there are other benefits to be gained by offering the software free. In addition to a potentially larger user base, people who buy Palm devices later will find that their data is already set for immediate synchronization.
Palm Desktop is also available in stores on CD-ROM, which also includes a printed Getting Started Guide and the adapter required to connect the HotSync cable's serial connector to your Mac's serial port, for $15. The adapter is also available by itself for $6 if you've just bought a Palm device and choose to download the software over the Internet.
What's New for Organizer Users -- Overall, most longtime Organizer users may not notice many changes, since much of the updating has centered around adding Palm device compatibility. The Instant Palm Desktop menu, formerly Instant Organizer, now works reliably instead of being an almost guaranteed way to crash your Mac. The Instant Palm Desktop menu appears at the right side of the Mac's menu bar, and you can use it to view tasks, today's appointments, and frequently used phone numbers, or to find and create records without launching the Palm Desktop application. Palm Desktop also provides Mac OS 8.5.1 compatibility and fixes a few bugs (including menu redraw problems).
Another major change is that Palm Desktop now runs only on PowerPC-based machines. Although Macs generally have more longevity than other computers, Apple hasn't shipped a 68K-based system since late 1996, and according to sources at Palm Computing, the program would still be in development in order to make it backward-compatible with 68K-based Macs.
Think Sync -- If you're a Palm device owner, you'll discover that there's more to this update than just the ability to share your handheld data with your desktop. The entire synchronization architecture has been rewritten, enabling third-party developers to write conduits that use your data with their applications. For example, Mac users can finally take advantage of the Palm OS's built-in Mail and Expense applications. Shana's Informed Palm Expense Creator takes your expense data and formats it into a variety of existing forms; Actual Software's MultiMail Pro Conduit lets your share email from Eudora or Eudora Lite (Emailer and Outlook Express support is coming soon) with either Mail or Actual's MultiMail Pro email client. Demonstration versions of each conduit are included in the Palm Extras, along with DataViz's Documents to Go (which lets you view Word and Excel documents on your Palm handheld).
Palm III and Palm V owners can also take advantage of faster HotSync operations, thanks to a new software library that resides in the Palm OS. Transfers of up to 115 Kbps are now possible, compared to a maximum of 56 Kbps for Windows users.
The new HotSync Manager does more than just oversee the HotSync process. To install a program onto your handheld, simply drop the file onto the HotSync Manager icon. From here you also control the configurations for multiple Palm users. My only complaint so far is that the interface would be better if the Install, Users, and Conduit Settings features were available in one tabbed window, rather than requiring repeated trips to the menu bar.
Dreaming of Beaming -- One surprise not enjoyed during Palm Desktop's public beta phase is infrared support for performing HotSync operations. Owners of the original Bondi Blue iMacs now have something to point at their IR port. By installing a collection of four libraries that live in your Extensions folder, plus four libraries on the handheld, you can HotSync without lifting a single cable. I've found this especially handy when I'm working on my PowerBook outside the office, when my Ricochet modem normally occupies the serial port (see "Tied Down No More: the Ricochet Wireless Modem" in TidBITS-366). Florent Pillet's utility Palm Buddy is already equipped to handle IR transfers, which means you can perform full backups of your data without wires.
Open AppleScript Access -- Unlike the closed-off Pilot Desktop 1.0, the new software is scriptable, with a handful of scripts included in Palm Extras. Annoying VCard enclosures (".vcf") can be automatically turned into new contact records. If you want to send someone's contact information via email, running the Mail Contact Info script from within Palm Desktop grabs the data and pastes it into a new message in your email program. Palm also included a PowerBook Setup Script for making it easy to toggle HotSync serial monitoring on PowerBook G3 Series machines, though I have to admit that I haven't had any difficulties with my PowerBook G3.
Apple's AppleScript group is reportedly enthusiastic about Palm Desktop and plans to offer additional scripts at their site. Scripts written for Claris Organizer are also available.
A More Advanced Organizer -- For some Palm device users, just being able to HotSync reliably will be a boon, while others will appreciate the ability to run third-party conduits and synchronize via infrared. PalmPilot users who have suffered with Pilot Desktop 1.0 for three years will be happy to find that Palm Desktop is now a modern PIM with the features that Claris Organizer users have enjoyed the entire time. In an upcoming issue of TidBITS, I'll go into more detail about how Palm Desktop works with your important data, and how Palm device owners can overcome a little interface shock to access advanced features not found in the Windows Palm Desktop.
Article 2 of 2 in series
by Jeff Carlson
Purchasing my PalmPilot a few years ago ended my flirtation with Mac-based personal information management (PIM) software. I experimented with Claris Organizer, but abandoned it because it couldn't synchronize with the PalmPilotShow full article
Purchasing my PalmPilot a few years ago ended my flirtation with Mac-based personal information management (PIM) software. I experimented with Claris Organizer, but abandoned it because it couldn't synchronize with the PalmPilot. Although Now Synchronize could transfer data between the handheld and Now Contact/Up-to-Date, it was buggy and unreliable.
That left me with Pilot Desktop 1.0, the software portion of the Pilot MacPac (which also included the serial adapter required to hook the Pilot's cradle to a Mac), but the program's glacial performance, gray Windows-like interface, and steep memory requirements ensured that Pilot Desktop acted only as a backup of my PalmPilot's data. As a result, I almost never viewed my schedule or looked up contact information on my Mac; grabbing the information from the handheld was always faster and easier.
Since installing Palm Desktop 2.1 (see "Palm Desktop Marks Return of a Familiar Organizer" in TidBITS-469), I'm not reaching for my PalmPilot as often. Now I'm looking up addresses and checking my calendar using either Palm Desktop or the Instant Palm Desktop menu. I'm using my PowerBook's modem to dial phone numbers, and I'm viewing and sorting my personal information in ways I'd never considered. Like an amphibian that exists comfortably either on land or in the ocean, I've partially migrated back to the desktop while retaining the advantages of accessing my data on a handheld device.
Palm Desktop appeals to two main camps of users: Palm device owners whose only option has been Pilot Desktop 1.0 and users of Claris Organizer, upon which the new software is based. Both parties (and anyone else for that matter) can download the free software from Palm Computing's Web site; Apple also mirrors the files.
Confusion Is Only Skin Deep -- If you're used to Pilot Desktop 1.0, Palm Desktop 2.1 may seem overly modular and scattered at first. But give yourself a few minutes to grasp its way of thinking and you'll be glad you abandoned the gray tones of Pilot Desktop.
One source of confusion for Palm device users is that Palm Computing kept Claris Organizer's names for the four modules that correspond to the four main Palm applications. In Palm Desktop, Date Book is known as Calendar, Address Book is called Contact List, the To Do List becomes Task List, and the Memo Pad is known as the Note List. Palm device users would appreciate more consistency, but once you mentally match up the names the confusion disappears.
Another source of confusion is Palm Desktop's multiple window interface. Pilot Desktop 1.0 (and Windows Palm Desktop 3.0) keeps all of its functions in a central window, but the Mac Palm Desktop uses a separate window for each module and displays records in their own windows. You could stack windows like Mah Jongg tiles, but arranging the windows to your liking and then saving the window positions works better, especially when linking records (see below).
These Are the Days -- I use the Calendar module most often because it provides the most information in one window. You can choose between Daily, Weekly, and Monthly views (which all share the same window). In the Daily view, the day's calendar runs in a column down the left side of the window, with an advancing bar at the far left indicating the current time. A second column displays your Task List for the day. Clicking the Tasks column header moves completed items to the bottom of the list. The weekly view displays the same information, but stacks each day's schedule above the list of tasks. The Monthly view arranges the days in a typical calendar grid, with appointments listed on each day by their time, and tasks listed with a preceding bullet.
You can click the arrows in the upper-right corner (or press Command and the right or left arrow keys) to display past or future dates. The plus and minus buttons in the Weekly view choose how many days to include in the view. Double-clicking the date at the top of the page brings up the Go To Date window, from which you can jump to any date.
The calendar can also create Event Banners, which equate to repeated untimed events in Palm's Date Book application. Although you can set any appointment to repeat during a variety of increments (daily, weekly, every other week, etc.), an Event Banner shows up as a single event stretching across multiple days, without an attached time.
Several features in the Mac Palm Desktop aren't available in the Windows version or even in the Palm OS. Each appointment can be assigned to a category; if you've associated colors with your categories, the resulting multi-hued calendar makes it easier to differentiate events without having to read each appointment's description. The downside to the implementation of categories in Palm Desktop is that you're limited to one master list that covers all modules; on the Palm device, each application can have up to 15 separate categories.
Making Contact with Addresses -- Palm Desktop Contacts can store more information than the Address Book's contacts on your handheld. For example, a long-requested feature for Address Book is now partially available: secondary addresses. Since the Palm Address Book contains fields for only one address, people often created two records to store work and home addresses. Now you can store all of that information within one Contact record in Palm Desktop. The secondary address, as well as information in fields such as Web site, Age, and Birthday, are stored as attached notes on the handheld.
Palm Desktop supports auto-completion of information in many fields. When typing phone numbers, it doesn't matter whether you include hyphens, periods, or spaces, since the numbers will convert to your preferred phone number style. And last, one of the Contact goodies I most appreciate is the Birthday field, which computes a person's age if you supply their date of birth.
Icons placed next to specific fields offer additional functionality. Clicking the envelope icon next to the Email field creates a pre-addressed blank message in Claris Emailer, and the icon next to Web Site field opens that field's URL in your Web browser. You can customize the actions attached to these icons with AppleScripts residing in Palm Desktop's Scripts folder. Although Palm Desktop should have used Internet Config for email and Web services, it's possible to extend Palm Desktop's functionality via custom scripts (which could in turn support Internet Config).
Palm Desktop's Find feature, accessible in any module, is especially attractive. When searching for a contact, it can display results as you type any part of a person's name or company title, which I far prefer to waiting for a search to execute.
Tasks, Notes, Lists, and Filters -- Palm Desktop's Task List and Note List are straightforward. Tasks can include a priority on a five-point scale ranging from Highest to Lowest, a completion date, and category. You can create repeating tasks and assign them reminders. Notes feature Title, Date, and Time fields in addition to the note text, a category pop-up menu, and a button for time-stamping comments in the text.
You can manipulate Palm Desktop's lists in useful ways. Clicking a column heading sorts the list according to the contents of the column. This applies to all modules, not just Tasks and Notes, meaning you can view your Contacts by last name, company name, or other field. To rearrange the columns, Option-click a heading and drag it to a new location.
Better yet, Palm Desktop lets you to filter your information. Each column header includes a pop-up filter menu in which you can define and save criteria for selecting the column's contents, such as all your friends who live in Idaho or who are in a certain category.
Attached to Attachments -- If you've synchronized your Palm device's data and played with Palm Desktop a bit, you've no doubt run into one of the bigger brain-twisting elements of the new Palm Desktop. What happened to attached notes? Under the Palm OS, you can create a note from within a record that includes miscellaneous information. When you open Palm Desktop, however, those notes aren't immediately apparent because they're stored in the Note List. Looking at the Note List for the first time can produce a moment of organizational panic: in addition to the records you entered in the Palm's Memo Pad, you'll find dozens of records marked "HandHeld Note:" then the name of one of the Palm's built-in applications.
This organization is in fact consistent with the way Palm Desktop stores its information internally and is the product of the program's capability of linking any record with any other record. If a record contains a link to another record, you see a paper clip icon with a down-pointing arrow. Clicking the icon displays a menu of items linked to the record, plus options for creating new attachments. When you choose a linked item from the menu, it appears in its own record window.
Let's say you want to add driving directions to a friend's new house. First you'd open his entry from the Contact list. His contact card displays in its own window. Choose New Note from the paper clip pop-up menu; a new Note window appears for you to type the driving directions in the main text field. Before you close the window, be sure to enter the following in the Title field: "HandHeld Note: Address Book". (If you don't, the note appears as its own record in the Memo Pad after you perform a HotSync.) After you close the window, the paper clip pop-up menu displays the number one to indicate that one note record is attached to that contact record.
You can link to existing records using drag & drop. Make sure both records are visible (in this case your friend's contact record and an existing note), then drag the gripper icon located in the upper left corner of the contact record window to the other record. You'll hear a click sound indicating that the records are now connected. You can also use the paper clip pop-up menu to attach an existing item to any record: Palm Desktop opens a floating window in the lower right corner of your screen from which you can drag your current record to any other item. This is often easier than pre-arranging your windows before establishing a connection between records, since you can hunt around for your other item while the floating window is open.
Change Your View -- Since I don't usually want to see all of the HandHeld Notes when I view my Note List, I take advantage of another aspect of Palm Desktop's filtering capabilities. The View pop-up menu in the upper left corner of the Note List window enables you to save the current state of your list. So, I've created a memorized view called No HandHeld Notes that hides any note containing HandHeld Note in the Title field. The View feature also lets you save the current sort order, column arrangement, and window positions. Similar View menus also appear on the Contact List and Task List - they're a great help.
Printing and Playing with Others -- Although Palm Desktop's printing capabilities aren't as robust as those in Now Contact and Now Up-to-Date, they're better than those in Pilot Desktop 1.0. Palm Desktop offers good control over what data gets printed and handles a variety of output formats, such as Avery labels, envelopes, or Day-Timer insert sheets. If you're bringing information in from another program, Palm Desktop's Import feature enables you to specify which Palm Desktop fields correspond to the incoming data. Be careful when importing - large data sets can cause performance to slow to a crawl.
Better than the Alternative -- There are a few things missing from this release which I hope Palm Computing will address. Palm Desktop doesn't support private records, so although your hidden records are invisible on your Palm device without a password, they're available for viewing on your Mac. I've set up my memorized view for the Notes List to hide private records, but that's not particularly secure. If you're more concerned about unwanted eyes accessing your data, consider using a Palm-based encryption program.
A good addition to the Palm's overall functionality is the capability to display alarms on your Mac; however, if you don't want this feature (the alarms appear as system-halting modal dialogs), you must disable the entire Instant Palm Desktop extension. I would also like to see an indication on Calendar records that shows whether the item is a repeating event or includes an alarm, as the Palm Date Book program does. Finally, there are persistent reports that HotSyncing doesn't work with Keyspan serial port expansion cards.
Given the significant increase in functionality from Pilot Desktop 1.0, plus the improved conduit architecture enabling third-party developers to access Palm device-based data, Palm Desktop is a winner on my Mac. It's now one of the few applications, such as my email client and Web browser, that's permanently active throughout the day.