Archive for the ‘Tips’ Category
Tuesday, May 6th, 2008
I just found this great Numbers tip on Fury&Frost.com:
You can use the INDEX() Function to transpose data to another table.
Read the post for a full explanation, but use the following function to get the results shown in the screen shot above:
=INDEX(Prefs::$A$1:$E$15,COLUMN(),ROW())
Good one!
Posted in Tips | No Comments »
Sunday, May 4th, 2008
One of the unique features of Numbers is the ability to place an image in a cell, or behind a group of cells. In the case of the latter, it can be a little confusing to figure out how to accomplish this trick.
I put together a short screen cast ...
Posted in Tips | No Comments »
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 »
Thursday, April 10th, 2008
Good Tip: Shift-dragging a window in Spaces will consolidate all of that app's windows in the target space.
Via Daring Fireball via Nat Irons
Posted in Tips | Comments Off
Wednesday, November 7th, 2007
I just found this great formatting tip over on the Apple Numbers discussion boards. A poster had the following problem:
He had a series of phone numbers formatted as 10 digits (i.e. 5035551212). He wanted to re-format the numbers to read as (503) 555-1212.
5|=vv (who is also a frequent ...
Posted in Formulas, Tips | 2 Comments »
Saturday, November 3rd, 2007
Forum member, JaxJason, is working on a short format book/tutorial on Numbers. To quote from Jason’s first post on the project:
Ok, here is my first attempt at a little book to help people pick up Numbers. It is written in a conversational tone. It is purposefully not written ...
Posted in Forums, Miscellaneous, Tips | 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 »
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, 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 | 3 Comments »
