auto.pilot
Well-known Member
- Joined
- Sep 27, 2007
- Messages
- 734
- Office Version
- 365
- Platform
- Windows
I spent considerable time searching and testing, but this has me stumped.
Using XL 2010. My headers start in row 6 and I have perhaps 500 rows of data. Periodically (every 3 to 15 rows), the word 'Sub-Total' is displayed in column F. There are also numbers and some blank cells in column F. I would like to set a page break such that no more than 30 rows of data are shown on any one page and 'Sub-Total' will be at the bottom of each page. However, I don't want a page break at every instance of 'Sub-Total' because it would result in some pages having only two rows of data. IE: There may be several 'Sub-Totals' on each page because they term appears every 3 to 15 rows.
I would ideally like to post a sample of my data, but can't do that using my office PC.
Would appreciate any help.
Thanks in advance.
Jim
Using XL 2010. My headers start in row 6 and I have perhaps 500 rows of data. Periodically (every 3 to 15 rows), the word 'Sub-Total' is displayed in column F. There are also numbers and some blank cells in column F. I would like to set a page break such that no more than 30 rows of data are shown on any one page and 'Sub-Total' will be at the bottom of each page. However, I don't want a page break at every instance of 'Sub-Total' because it would result in some pages having only two rows of data. IE: There may be several 'Sub-Totals' on each page because they term appears every 3 to 15 rows.
I would ideally like to post a sample of my data, but can't do that using my office PC.
Would appreciate any help.
Thanks in advance.
Jim