How to fill a series of dates in Numbers.app
Quick Mac Tip, 11 March 2012
It’s not immediately obvious how to fill down a series of dates, perhaps a week apart, in Numbers.app on the Mac, but it’s extremely easy. Here’s how.
A reader, Patrick, spotted last week’s Excel Tip, How to fill a series in Excel so it’s not a drag, and complained of having difficulty filling a series of dates in Numbers on the Mac. I mentioned just dragging down. But then Patrick explained that he wanted the dates to be a week apart. Dragging down on a single date increments it by 1 day, not 7.
There’s a tiny bit of work to set up filling down a series of dates, but it still involves just dragging down. Here’s what you do.
- Open a
- In cell A1 (or whichever cell you need) enter a date, eg
01 February 2012and press
Tabto confirm it. The cell may change its display format.
- In cell A2 enter the next date you need, eg
08 February 2012.
- Select both dates then grab the handle in the bottom right corner and drag down. A series of dates is filled.
The Cell Inspector
Cell Inspector to change the date format for the selected cell or cells.
If you format the starting cell before you fill down then all the cells will have the same formatting. To format cells:
- Select one or more cells.
Show Inspectorfrom the
Viewmenu. The Inspector window appears.
- Select the
Cell Inspectortab. It’s the tab whose icon shows the number
42inside a rectangle.
Date and Timefrom the
Cell Formatdropdown menu.
- Select the format that suits you. The format is applied to the selected cells.
- Close or move the Inspector window when you’re finished.
While writing this Tip I played with filling series of dates. I tried 29 February 2012 followed by 28 February 2013. I also tried dates going back in time.
Experiment for yourself and have some fun.
Do you use
Numbers on the Mac for your spreadsheets? Let us know in the Comments how this Tip helped you.