print only range that contain information in excel 2007
 

i have a large worksheet to cover a large number of possible inserted entries,
all cells show blank until entries are copied and pasted in the worksheet.
The amount of entries vary. Is there a way to set the workseet to print only
the range of cells with information in them