Friday, August 22, 2008   
  Search  
 
 
Register  Login  
Forums  
     Minimize  

Welcome to MeraWindows forums.

Thank you for being at the Microsoft Windows Community Site. You may have to register before posting in forums. It's absolutely free. After registering, you can get all the benefits available to our registered members, you can access our Downloads section, you can participate in contests, etc. You can post in forums in English as well as in Hindi, in fact we encourage you to use Hindi in your posts. If you have any problem with registration or login, please contact us.
     
  


 
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Excel  Exclude blank rows in a Print Range when printing
Previous Previous
 
Next Next
New Post 5/8/2008 12:47 AM
User is offline inam81
2 posts
Member


Exclude blank rows in a Print Range when printing 

Hi,

I have a sheet with 200 rows. Some of my clients may only use a few rows and some may use all 200. I would like to know how to prevent Excel from printing several blank pages if a client only uses 10 or 15 or 20 rows. Currently the range is covering all 200 rows. I know this can be done by selecting a new range of cells to print but not all of my clients are techy enough to do this. I want to make it as easy for them as possible.

Thanks!
 
New Post 5/13/2008 7:53 PM
User is offline Kingshere
3 posts
Member


Re: Exclude blank rows in a Print Range when printing 

Hi,

 

I'm new to this forum & glad to help you.

You can try using filter. Block the range of cell for printing and go to data - filter - filter . you can see a drop down arrow in the first data. click on it and uncheck blank. Go ahead to print the sheet by using selection print range where blank rows are eliminated.

this is one method i found. Vba should do your task vary easy.
 
 Page 1 of 1
Previous Previous
 
Next Next
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Excel  Exclude blank rows in a Print Range when printing
   Get Your Own E-Mail Account @MeraWindows.com Minimize  
New Page 1 New Page 1
Show your cool quotient with @merawindows.com email account
     
  
 
 
Terms Of Use   Privacy Statement  
© 2008 MeraWindows.com