ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I set the pages to print the same length for all (https://www.excelbanter.com/excel-discussion-misc-queries/184722-how-do-i-set-pages-print-same-length-all.html)

doc control

how do I set the pages to print the same length for all
 
I am using Excel 2003. I have a table that is 20 pages in length. The first
couple of pages appear fine but then there will be a page that only has a
couple of lines of the table on the page. When I try to reformat it the text
becomes too small to read.

Gord Dibben

how do I set the pages to print the same length for all
 
What happens when you clear the print area then reset?

Where are your pagebreaks set?

Automatic or Manually set?

How many rows to "page"?

Lots of things to check.


Gord Dibben MS Excel MVP

On Tue, 22 Apr 2008 13:39:17 -0700, doc control <doc
wrote:

I am using Excel 2003. I have a table that is 20 pages in length. The first
couple of pages appear fine but then there will be a page that only has a
couple of lines of the table on the page. When I try to reformat it the text
becomes too small to read.




All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com