1. Drag the Fill Handle of a single cell to copy that cell. The Fill Handle is at the bottom right of any selected cell or group of cells. 2. Drag the Fill Handle of a cell containing January, Jan, ...
We mostly use the fill handle or auto-fill options for date columns, and sure, they work. But once you need hundreds of rows, weekly intervals, or dates that have to shift when your data changes, ...