Ask Your Question

I want to auto populate a row of dates in a form for a diary

asked 2018-02-11 16:48:54 +0100

questioning. gravatar image

I want to auto populate a row of dates in the first column. I am trying to do a diary with some dates in the first row. has someone tried it already? can you please help.

edit retag flag offensive close merge delete


Hello @questioning., it is not clear what you meant by "a row of dates in the first column".

Rows are horizontal, Columns are vertical.

A Row in a Column is a single Cell.

Did you mean you want to have the first column auto-populated with dates ?

librebel gravatar imagelibrebel ( 2018-02-11 17:37:55 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-07-16 19:37:19 +0100

LeroyG gravatar image

updated 2020-07-16 20:35:11 +0100

Apply to Calc.

If do you want that each row beggins with a sequence of dates, type the first date, press Enter, select again that cell, and drag down the fill handle (the little square in the bottom right corner of the selected cell).

AutoFill dates

More LibreOffice Help on Automatically Filling in Data Based on Adjacent Cells.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-11 16:48:54 +0100

Seen: 56 times

Last updated: Jul 16 '20