Need to change open office settings to fill complete page

[katzdvd]

I am creating a spreadsheet which requires 14 columns down, & 14 columns across. I am able to do this, except, I want to print it in landscape & have it fill the entire sheet. I am able to print landscape, but unable to get the project to fill the entire sheet. What I am ending up with is the complete project printed on 1/2 the sheet.

I am sure there is an easy setting somewhere, but I can't seem to locate it. Anyone have any experience with this?
Thanks, katz

[Dialysis1]

Are all 14 columns filled or are they empty?
If they're filled you can try widening the columns. If they are empty, you can add borders to them to make them visible.

[PurpleDemon]

Have you tried highlighting your print area, go to format/print ranges/define to see if that fixes it.

I'm just starting to learn this program, but hopefully that might what your looking for.

Good Luck

[katzdvd]

They are filled w/ all the data that needs to be in them; What I have done so far is to r click on the columns/rows & manually adjust each one to the size that I need. I was hoping to discover a setting that I could apply to all at once, but I couldn't find it. My method worked out ok for this "small" project, but if I had a larger one to do, it would be very tedious.