I download the invetory templet from microsoft that had 120 row. I then
copied two rows, then selected a bout 100 more row, did a paste special using
formts to create the addittional rows (tow rows to get the alternating
white/grey efffect). I simply cleared the Print Area. When I did a print
preview I had to use the next button to see the entire worksheet.

"cdefen" wrote:

I downloaded an Inventory Template in Excel to do a tool inventory for the
Insurance Company. The number of rows stops at 120, I will need several
hundred more to inventory my tools. Problem is, when I go beyond 120, I can
see it and save the info, but cannot print it, even when I expand the Print
Area. Can someone please help? Any Help Appreciated.