Use ctrl+; shortcut in calc for multiple cells or automatically

I can press ctrl + ; to insert date in a cell. But I want to fill many cells at once, but it fills only one cell even on selecting multuple cells.
How to fill multiple cells?
Also, can I do this automatically based on a condition inside a formula?
Using a VBA or macro is the last resort.

Thanks for helping.

Enter the above key combinations in sequence.

Ctrl+; â–ş Ctrl+D

2 Likes

That’s good to know but I don’t need to fill continuously but at regular or at times irregular intervals.