Make Office Better
Top tips for the best office programs
ONLYOFFICE
Autofill spreadsheets with days, months and years
Version 8.3 of OnlyOffice, released in February, makes it easier to auto-fill spreadsheet cells with weekdays, months and years. Start with a date like 1/1/2025, then select your cells. Now right-click the ‘fill’ icon in the bottom cell (a small green square at the bottom right of a cell – 1 in our screenshot below) and drag it to where you want the weekdays, months or years to appear. Now release your mouse button and you’ll see options to fill in days (including weekends), weekdays, months and years 2 . Click what you want and they’ll appear in the empty cells you’ve selected.