I am making a spreadsheet that has only one worksheet but will need to divide the data onto multiple pages.
Specifically there will be 4 columns. The number of rows is variable.
I need to be able to enable the print area to fit to each page from Column A to Column D and each row of 50.
So From A1 - D50 would be on one page and A51 - D100 would be on another page.
The data will have a graphic file embedded as well on each page.
As it stands now, I can get the fit to page for a one page document but I am having problems making it work for multiple pages.
Can someone help me?
Specifically there will be 4 columns. The number of rows is variable.
I need to be able to enable the print area to fit to each page from Column A to Column D and each row of 50.
So From A1 - D50 would be on one page and A51 - D100 would be on another page.
The data will have a graphic file embedded as well on each page.
As it stands now, I can get the fit to page for a one page document but I am having problems making it work for multiple pages.
Can someone help me?
