Printing whole spread sheet

My computer only prints the first two columns of my spread sheet. How do I get it to print all three columns. There is plenty of room on the paper.

Try to clear print range: Format-Print Ranges-Clear

Set a print range that includes the area(s) you want to print via Format | Print Ranges | Define

If this answer helped you, please accept it by clicking the check mark :heavy_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.

In addition to the above answers:

Switch to the page break preview from the View menu to see if the third column is included into the print range (if it is not, it will be grayed out). To expand (or to shrink) the print area, simply move its borders (outer thick blue lines).

Setting the print range is not a complete solution because the contents in the print range may be bigger than the paper. The print range does not specify scaling of the contents - it only specifies what part of the spreadsheet is to be printed. After defining the print range, go to the Format->Page dialog, click on the Sheet tab and under the heading Scale, select “Fit print range(s) to width/height” and select what you want to get.

Calc doesn’t squash data in some direction. It scales it proportionally until it fits defined dimensions (like, say, your example’s 1 page). So, both too long or too wide spreadsheet would end up simply small (not squashed) when fit to one page.

Thanks. You are right. I suppose “squish” suggests an alteration in aspect ratio. I will remove this part of my answer as your comment explains it better!