im new to this software and use to office how do I set the print area in both the spreadsheet and word type document in libre?
REVISED - In Calc, highlight the cells you want to print, click on Print, be sure to select the option Selected Cells (default is Selected Sheets) in the dialog box. Then OK.
In Writer, highlight the lines you want to print, click on Print, be sure to select the Selection option in the dialog box, then OK.
Works the same in both versions v5 and v6.
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.
Libre Office Text is excellent but I’m really missing Lotus123 
I understand (although it is Writer not Text). And I miss DOS, and Borland Turbo C, and Pascal.
In Calc,
Select your Print area, then
Format > Print Range > Define
This response was exactly what I needed! I was struggling with figuring this out. Thank you Lou!