You don't know from your profile which version of Excel you are using, but open up the Workbook in Page View (in Excel 2010 and later this option is bottom right of screen), find the last row or better still the Header & Footer space and put a line in there.
Bookmarks