Forum Discussion
Govvy
Nov 10, 2022Copper Contributor
Cold flu sheet
I've had a number of colds and after covid, I was thinking I would like to record over the course of a year when I have a cold. I wasn't sure how I should be inputting my data into a sheet. I wanted ...
Govvy
Nov 10, 2022Copper Contributor
HansVogelaar You have literally put a whole year down of dates, is the a quick way to do that?
HansVogelaar
Nov 10, 2022MVP
I entered the 1st of January. With that cell selected, I clicked Fill > Series... in the Editing group on the Home tab of the ribbon.
In the dialog, I selected Columns, and entered the 31st of December in the "Stop value" box, then clicked OK.