Excel is pretty smart. It should adjust when you add new rows.

In fact, you may find that excel doesn't react to rows that are deleted. You
can use some of the techniques at Debra Dalgleish's site to reset that last used
cell:

http://www.contextures.com/xlfaqApp.html#Unused

Paperback Writer wrote:

Is there a way to set the print area so that it automatically adjusts down as
new lines are added?

--

Dave Peterson