you can do this by hiding empty rows in between your data rows. you can
do this very quickly by using commands.

first select your data range which you want to print (from top to
bottom).
then File Print Area Set Print Area

now when you want to take print Just apply following commands.
click on cell in row next to your entered data.
press Ctrl+Shift+Down Arrow Key (it will select all blank rows to last
row which has functions).
Now hold only Shift key and press Up Arrow. It will deselect the row
which has data (Functions).
Now press Ctrl+9 (nine below F8 not on numeric key pad), it will hide
your empty rows.
and at last press Ctrl+P to print the document.

It seems long process but it is't so. It take just 3 to 5 Seconds to
take a print. (because I used to do this on regular basis)


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=537072