How do I shrink to fit in open office?

How do I shrink to fit in open office?

First font size: select the data, right click in the selection and select Format cells, select the Font tab and reduce the value in Size. Then select Format from the menu, then Rows > Height and reduce the height value until the data fits on a single page.

How do I print a spreadsheet in landscape on Open Office?

Single Printing

1. Click “File” and then “Print” to open the Print window.
2. Select the “General” tab.
3. Click “Properties” to the right of Details.
4. Select the “Layout” tab.
5. Click the drop-down arrow beneath Orientation.
6. Select “Landscape” and then click “OK.” Your document will now print in landscape orientation.

How do I print all columns in OpenOffice?

Printing rows or columns on every page

1. Choose Format > Print Ranges > Edit. On the Edit Print Ranges dialog, type the rows in the text entry box under Rows to repeat.
2. To repeat columns, type the columns in the text entry box under Columns to repeat. For example, to repeat column A, type $A.
3. Click OK.

How do I change the view in open office?

To set view options, perform the following steps:

1. Click View > Zoom. The Zoom & View Layout window is displayed.
2. Select one from the following options to specify the Zoom factor setting. Optimal.
3. Select one from the following options to specify the View layout setting. Automatic.

How do you fit to page in open office?

Adjusting the maximum number of pages on which the print should fit:

1. With the spreadsheet open, select Format > Page…
2. In the dialog that appears, select the Sheet tab.
3. At bottom of the dialog there is a scale control labeled, Fit printout on number of pages.
4. Click OK.

How do I change from portrait to landscape in OpenOffice?

In your open document in OpenOffice.org:

1. Open the Styles and Formatting window [F11] (or choose Format –> Styles and Formatting).
2. Click on the Page Styles icon (fourth icon from left).
3. Default should already be highlighted.
4. In the dialog that appears, give the new page style a descriptive name, e.g. Landscape.

How do I print vertically in open office?

Printing a spreadsheet in the center of the page

1. Select Format → Page… from the main menu.
2. Select the Page tab.
3. In the Table alignment section, select (or deselect as desired) the boxes next to Horizontal and Vertical.

How do I print all pages in OpenOffice Calc?

To print all of the sheets, go to File > Print and select Options. The Printer Options dialog has only two choices: Suppress output of empty pages and Print only selected sheets. The Print only selected sheets. This choice affects the print preview, export, and printing of your spreadsheet.

How do I make the page full screen in open office?

You enter full screen mode using View > Full Screen or ⌘⇑J. Exit full screen mode by clicking on the Full Screen toolbar button or using ⌘⇑J again.

How do I enlarge the page in open office?

Choose Format > Page. In the dialog box, choose the Page tab. On the page tab, select a page size from the drop-down box. Click OK.

How do I change print size in open office?

How do I set print area in open office?

Setting the area to be printed

1. Go to the desired sheet.
2. Click and drag to select (highlight) the area of the sheet to be printed.
3. Select Format → Print Ranges → Add from the main menu.
4. Repeat the above steps for each sheet of the file to be printed.