Print Only Records in Excel File

HELP! I’ve been driving myself crazy trying to find a solution that might not even exist.
I have created a database of information in Excel. Each row represents a record. I would like to customize it to make it easy for multiple users of different skill levels.

I Have set up the print are to cover 50 records, but perhaps there may only currently be 10 or so records. Instead of asking users to select cells with data and print the selection, I am wondering if I can create a macro that will print only cells with data within that print area range.

Can this be done? Thanks in advance.