Share via

Different dates on each page.

Anonymous
2018-11-18T03:34:32+00:00

How can I place a date when printing - ex. from November 1, 2018 to November 30, 2018 for each page a different date?  Please help...in excel and word.

Thank you!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2018-11-18T16:49:31+00:00

    Are you printing 30 copies of a single same page or is your print range 30 unique pages of data from one sheet?

    Or a single unique page from each of 30 worksheets?

    Gord

    Was this answer helpful?

    0 comments No comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2018-11-18T11:02:20+00:00

    That is not possible.

    You have to write the date into a cell for each page and setup your page layout in a way that this cells, resp. rows are printed at the top of each page. Use the Page Layout View for that and adjust the page breaks manually.

    https://support.office.com/en-us/article/insert-move-or-delete-page-breaks-in-a-worksheet-ad3dc726-beec-4a4c-861f-ed640612bdc2

    Andreas.

    Was this answer helpful?

    0 comments No comments