I’m a longtime AppleWorks user. For a somewhat clunky all-in-one, it’s a pretty capable piece of software, capable of leaping tall bounds, and its spreadsheet has almost all the functionality you’d ever need. But my shiny new copy of iWork arrived a few weeks ago, so I’ve been trying to wrap my head around Numbers, its new spreadsheet piece.
Yesterday I went looking for how to do a “data fill” in Numbers — I needed a column filled with the numbers from 205 to 386 and I didn’t want to type them all in. In AppleWorks this was done by selecting Calculate \| Fill Special from the menu, followed by entry of a start value and an increment. In Numbers it’s almost unbelievably intuitive (so intuitive I couldn’t intuit it). Witness the following 10-second how-to video (created in the equally too-intuitive new iMovie):