View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Again printing with hidden rows

I cannot replicate the problem in 2003.

Set print range A1:G100

Prints on two pages.

Hide rows 25 to 75

Prints on one page.


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 16:06:36 +0000, jamalhakem
wrote:


Hi Fred
I am so unclear?
The question is that with hidden rows I can print only the unhidden
row, so if the page contain 10 unhidden rows I have them in one page,
the next with 10 pages, etc...
What I want is to fit let us say the 20 unhidden rows in 2 pages in one
and print them in 1 page
Hope I am clear
Jam