DatePop is built for filling a column fast. After every pick the selection moves on, so the rhythm is click a date, click a date, click a date, with no need to reach for the next cell.
Fill a column one date at a time #
- Open the pane and click the first cell of the column, for example the first empty cell under a Due date header.
- Click a date in the calendar. The cell gets the date and the selection moves one cell down.
- Click the next date. Repeat until the column is done. Use the arrows at the top of the calendar when a date is in another month.
A cell that already holds a date is not skipped: the line above the calendar shows what the next cell holds (Now: 2026-11-06) and the next click replaces it. Click Undo last date within about 10 seconds to put the previous value back.
Fill across a row instead #
Open the menu at the top left, choose Settings and change After picking a date, move to Right to fill a row, or to Off to keep the selection where it is. Down is the default. The choice is remembered on your computer.
Write the same date into many cells at once #
Select the whole range, for example a block of 20 rows, and click a date: every selected cell gets it. If you select a whole column, DatePop fills only the used rows plus one, so the sheet’s million rows are not touched. A pick never writes to more than 10,000 cells, and DatePop asks first above 1,000.
Rows hidden by a filter are skipped, so you can filter a list to the rows you want and set their date in one click.
Different dates in each cell #
For a run of dates, such as every workday of a month or the second Tuesday of every month, use Fill a date series (Pro). To write today’s date everywhere, select the cells and click Insert today.
Good to know #
- You can mix typing and picking. Type a date by hand wherever that is quicker, then click the next cell and carry on.
- The dates are real Excel dates, so a column filled by DatePop sorts and filters correctly.
- If the date shows as a number or as ####, see The date is wrong or shows as a number.