
It’s easy to change the format of your number, dates and other numerical values in Numbers 09.
First, click on a cell.Then bring up the Inspector with the Inspector button on the toolbar, or from View>Show Inspector.From the Cell Format dropdown, select the type of formatting you’d like.Each one has a special set of formatting options ... read more
October 19, 2009 in Tips by David Schloss

This really interesting piece from TUAW (The Unofficial Apple Weblog) looks at how the iWork suite can be used not as a business tool, but as a way of editing one’s images without having to own an image editing program. read more
September 19, 2009 in News by David Schloss

It doesn’t take a lot to make a spreadsheet more readable. A splash of color, a bit of attention to the way the eye scans across the page is all that’s needed to make an unbearable document readable, nay, pretty.
It’s a breeze to change the look of a table in Numbers, and this functionality is ... read more
September 3, 2009 in News by David Schloss

I spent the better part of a year as an Excel spreadsheet programmer back in my IT days and as a result, one of my pet peeves is having to look at a spreadsheet that’s poorly formatted. When you’re crunching numbers there’s nothing worse than a column that’s so narrow that it obscures content or ... read more
September 2, 2009 in News by David Schloss

Sometimes you want a spreadsheet to have a column for calculating or storing some value, but you don’t need to see it when you’re looking at the spreadsheet. To hide any column (but leave it active) simply right click on the column header and select “Hide Column”read more
August 29, 2009 in News by David Schloss

In both Pages and Numbers you can rotate an image placed on the canvas by clicking on it and bringing up the Inspector, and then brining up the settings for the image and entering a number for the rotation. Or, if you’d like to save a lot of time, click the image and then hold ... read more
July 7, 2009 in News by David Schloss

In this article we cover the steps to create a 3D pie chart in Numbers and talk about how to use the Inspector to “explode” the pieces of your 3D pie chart (and other chart types) so that the wedges move apart from each other and appear to float in space. There’s another way to ... read more
June 21, 2009 in News by David Schloss

Apple's Numbers spreadsheet makes it easy to create a really gorgeous looking three-dimensional table in just a few steps. This example will create a 3D pie-chart, but it's just as easy to make a 3D bar chart, line chart and many other types of graphical displays. While some of the elements change in different types of charts, the process is the same. read more
June 20, 2009 in News by David Schloss

MacCreate commenter Beverly reminded us of a great keyboard shortcut for those of you using iWork if you only want to copy the style of words then paste into completely different words – select the style of the words Command-Option-C, then select the text you want to apply the style to and press Command-Option-V.
That’s for that ... read more
June 4, 2009 in News by David Schloss

iWork’s programs (Keynote, Pages and Numbers) let you drag-and-drop images into the documents directly from the Media Browser, Finder or many other programs. When you insert a photo, you’re actually copying the image into the document.
If the photo is large, this can take up a large amount of space. Let’s say you drop a photo ... read more
May 24, 2009 in News by David Schloss

iWork (Pages and Keynote) can create text-effects quickly and easily. Here’s how to make a bit of text take on a drop-shadow effect.1. Select Your Text
2. Open The Inspector
3. Switch to the Graphic Inspector
4. Control Your Shadow
5. View Your Effect1. Select Your TextCreate or open a document and select some text, in this case, ... read more
May 22, 2009 in News by David Schloss

The iWorks programs (Keynote, Pages and Numbers) use a floating palette called an Inspector to provide access to the layout and formatting tools. Most people only open up a single inspector and switch between the controls via the tabs at the top, but it’s possible (and easy) to open multiple inspectors, leaving them open to ... read more
May 5, 2009 in News by David Schloss

As you design, whether a brochure in Pages, a website in iWeb, a spreadsheet in Numbers, even an email in Mail or a database layout in FileMaker Pro, or in just about any application — at some point you'll want to match a color that's in one element to use in another. But how to know exactly what color something is? And what about when you want to match a color used in one application to an element in another program?Luckily, Apple's own Color palette enables you to sample any color available on your Desktop — not just in the program you opened it from, but from any open window or document. Think about it... with some creativity you can even sample the colors in your home or office. read more
March 29, 2009 in News by David Schloss