Search This Blog

Sunday, September 9, 2007

Numbers Auto-Fill and Print View

Numbers Auto-Fill and Print View: "Update: Thanks to Michael Kaltenecker and Beverly Martin for tipping me off to even easier auto-filling in Numbers that doesn't require a formula. It turns out that Numbers is extremely clever, and all you have to do is give it enough data work with and it will automatically figure out the necessary steps. So, for instance, if you enter 1 in A1 and 2 in A2, select both cells, and then hover over the lower right corner of A2 until the cursor changes to a black plus sign, you can then drag the selection down and cause Numbers to fill in 1, 2, 3, 4, and so on. Enter 1 and 3, and drag down, and you'll get only odd numbers. Enter Monday and drag down, and you'll get the days of the week. Enter 01-Sep-07 and drag down, and you'll get all the dates that follow. You can even enter 01-Sep-07 and 08-Sep-07, and drag down to get a cell for each seven days.

"


TidBITS - http://www.tidbits.com/