Hello, I am struggling with the attached which is a report from a DB. Ideally I want to save to PDF so it's easy to view.
Is it possible to set down to row 21 to print on a first page, then upto and including column AK on page 2, columns AL to AU on page 3 and AW to BY on page 4. This is with the top 21 rows not showing on any of pages 2, 3 and 4?
Thank you very much
Darren.
Setting Page Breaks/Print Area
-
- 3StarLounger
- Posts: 313
- Joined: 04 May 2010, 15:18
Setting Page Breaks/Print Area
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78446
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Setting Page Breaks/Print Area
Not with the current setup, but it can be done if you're willing to insert an empty column in column AL. See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 313
- Joined: 04 May 2010, 15:18
Re: Setting Page Breaks/Print Area
Thank you Hans, I can deffo work with this.
Best
Darren.
Best
Darren.