Archive for the ‘Tips’ Category
Wednesday, September 26th, 2007
Forum member Ashka shared a good tip on the forums yesterday dealing with Merging and Splitting cells. Basically, there is a bug in how Numbers handles split cells that were merged from an odd number of cells. This is Ashka's work around:
Merging two cells then splitting them works fine, as ...
Posted in Forums, Tips | No Comments »
Tuesday, September 4th, 2007
This tip allows you to show formulas in Numbers just as you would in Excel.
The secret is to place an apostrophe in front of your formula. For instance, if you type =SUM(10,20), Numbers would normally display 30. If you type '=SUM(10,20), Numbers displays =SUM(10,20). That's correct, it ...
Posted in Tips | 4 Comments »
Friday, August 31st, 2007
Quick Post - Two Great Resources for Apple iWork Numbers
Apple Numbers Discussion Forum - This is a great place to get friendly and helpful answers to any question about Numbers.
Apple iWork Numbers Video Tutorials - Apple has created a very helpful set of short videos to help familiarize you ...
Posted in Tips | 3 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 »
Monday, August 27th, 2007
Have you ever needed to type a special character like ©, or ö? Since these are not on your keyboard, you usually have to go digging into a special symbols palate.
No more!
LiquidCity has an excellent reference to almost every special character and their keyboard shortcuts. You can find ...
Posted in Tips | No 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 »
Wednesday, August 22nd, 2007
Hello everyone, just a quick post tonight, since I am up to my ears trying to deal with Numbers time formats. I'm working on a time sheet template, and the thing is giving me fits. I suppose I should be thankful for all the posting material this is ...
Posted in Tips | 5 Comments »
