Numbers
At $9.99 each for Pages, Numbers or Keynote it looks like it’s not all fun and games for the iPad but this keeps you to one device. If you need to do longer typing you can of course use the Keyboard dock – so what are you waiting for? That novel needs you!
iWork Now ... read more
January 27, 2010 in News by David Schloss
In Numbers 09 it’s possible to quickly change the formatting for your cells through the inspector, but it’s also possible to create special types of number entry fields such as sliders or drop-down menus. This helps users of your spreadsheets interact with your data more efficiently.
To begin, start off with the same steps in this ... read more
October 20, 2009 in Tutorials by David Schloss
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 Effect
1. Select Your Text
Create 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