I have the Excel worksheet as shown below on the picture. The data are on the yellow-marked pages. I only need to print the yellow marked pages with continuous pagination.

So the result should be: 3 pages printed, with Page 1, Page 2, Page 3 in the footer.

enter image description here

How can I achieve this, please?


Solution from Bernard Liengme available here:

Set your first print area block - ie pages 1 and 2 in your image.

Then highlight the second area you want to print (page 6 in your image), and in the Page Setup group click the Print Area dropdown - it now contains Add Print Area. Use this to add as many additional ranges as you need.

enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.