I HAVE A 12 MONTH CALENDAR AND WANT TO ENTER SAME DATA ON THE SAME DATE FOR EACH MONTH

Question

I HAVE A 12 MONTH CALENDAR AND WANT TO ENTER SAME DATA ON THE SAME DATE FOR EACH MONTH

Michele Rosche 0

EmilyS726 279.7K Reputation points Independent Advisor

2026-11-10T15:22:05.2433333+00:00

Does your calendar have all 12 months on one worksheet, or does each month have its own worksheet tab at the bottom?

The solution will be different depending on how your calendar is organized.

1 answer

Your answer

EmilyS726 279.7K Reputation points Independent Advisor

2026-11-10T15:22:05.2433333+00:00

Does your calendar have all 12 months on one worksheet, or does each month have its own worksheet tab at the bottom?

The solution will be different depending on how your calendar is organized.

Answer 1

If your months are separate sheets, I would group them and type the entry once.

Hold Ctrl and click each month sheet tab, or click the first month tab, hold Shift and click the last month tab. Click the cell for that date and type the entry. Excel puts the same entry in the same cell on every grouped sheet.

Right-click a sheet tab and choose Ungroup Sheets right after that, before you edit anything else. Any change you make while the sheets are grouped applies to all of them.

This only works if the same date is in the same cell on each month sheet. If all 12 months are on one sheet, copy the entry and paste it into the matching date cell for each month instead.