I have a column with the first top-six cells as:
- column D1: Total days worked
- column D2: (formula for total days worked)
- column D3: empty cell
- column d4: Total Hours Worked
- column d5: (formula for total hours worked)
- column d6: empty cell
how do I copy these first six cells in the column and repeat them vertically over the rest of column D?
I can drag the bottom right corner to copy and paste them, but I want it to repeat forever instead of just the number of cells I can vertically scroll down to with my mouse.