Tip: How To Use The Index Function To Transpose Data In Numbers

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!

Screen Cast: How To Place An Image Behind A Table

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 ...

Tip: Consolidate Windows In Spaces

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