Archive for the ‘Hacks’ Category
Friday, April 18th, 2008
One of the most frequently asked questions on the Apple Numbers Discussion forums is how to rotate text (for instance, make the text vertical). This is a common function in Excel, but unfortunately, it is not available in Numbers '08. However, while you cannot rotate text in-cell, you can ...
Posted in Hacks, Tips, Tutorials, Video | No Comments »
Friday, October 5th, 2007
I would like to share a very interesting tip that forum member 5|=vv posted on the Apple boards.
The question posed was:
I was wondering if two columns have the same value can I establish a condition that would underline one column?
Example:
Orig. Price Current Price
$200,000 ...
Posted in Hacks, Tips | No Comments »
Monday, October 1st, 2007
JaxJason has shared another cool technique on the forums. This time he shows us how to create a "fuel gauge" style chart.
It works by using three pie slices. The middle one is our 'needle'. By changing the size of the first pie slice and adjusting the third ...
Posted in Charts, Hacks, Templates | 1 Comment »
Friday, September 28th, 2007
Forum member and Numbers guru, JaxJason, has posted a workaround for the lack of Solver support in Numbers. Jason can explain it better than I can, so here is his quote from the forum:
This one is a solver workaround that uses a second table with about 1000 rows ...
Posted in Forums, Hacks, Tips | No Comments »
Wednesday, August 29th, 2007
Rob Griffiths has a great tip on Macworld.com for placing images behind cells in a Numbers document.
Here’s the secret: in Numbers, any placed grid also has a fill, and it defaults to filling with white. In essence, each grid contains two layers: the bottom “grid” layer is filled with white, ...
Posted in Hacks, Tips | No Comments »
Wednesday, August 29th, 2007
I found an interesting technique a while back on the Juice Analytics site, that works well in Numbers.
The technique uses the REPT Function, to create neat in-cell graphs.
The Numbers manual defines REPT as:
REPT(text, copies)
text: The text expression to be ...
Posted in Functions, Hacks, Tips | 2 Comments »
Saturday, August 25th, 2007
Here is a great tip I found on the Apple discussion boards courtesy of Neil Barman.
You can use Numbers to export your address book entries to a comma separated values (csv) file.
Here's how you do it:
Open Address book, then select the entries you wish to export. Drag them into ...
Posted in Hacks, Tips | No Comments »
Tuesday, August 21st, 2007
Numbers user Marcus Wilhoit was the first person that I came across describing using AppleScript’s GUI support for user interface (UI) scripting, to compensate for the lack of AppleScript support in Numbers ’08.
He describes it this post on Apple Discussions forum:
http://discussions.apple.com/thread.jspa?threadID=1090948&tstart=0
Basically, the method allows a user to interact with the ...
Posted in Hacks | 3 Comments »
Sunday, August 19th, 2007
NEW VERSION ADDED 8/23/2007
One of the most glaring missing features of Apple iWork Numbers '08 is the ability to get data into the sheet from outside sources. A very common need is to pull in stock quotes, then manipulate the data. While, I have not found a ...
Posted in Business, Hacks, Personal Finance | 6 Comments »
