Overview of Worksheet Print Options

Formula One for Java's many printing options are available in several menus and dialog boxes. The quick guide below will help you determine where to look for information about the print option you want to set.

Quick Guide to Print Options

The print options are listed in alphabetical order.

Print option How to set that option For more information

Black and white printing

Select File > Page Setup and click the Sheet tab.
Check No Color, then click OK.
Specifying Sheet Print Options

Center the printout on the page

Select File > Page Setup and click the Margins tab.
Choose values in the Center frame, then click OK.
Specifying Margin Print Options

Color printing

Select File > Page Setup and click the Sheet tab.
Un-check No Color, then click OK.
Specifying Sheet Print Options

Footer

Select File > Page Setup and click the Headers & Footers tab.
Enter codes in the Footer frame, then click OK.
Specifying Headers and Footers

Grid lines, print or hide

Select File > Page Setup and click the Sheet tab.
Check or uncheck Grid Lines, then click OK.
Specifying Sheet Print Options

Header

Select File > Page Setup and click the Headers & Footers tab.
Enter codes in the Header frame, then click OK.
Specifying Headers and Footers

Margins

Select File > Page Setup and click the Margins tab.
Choose values in the Margins frame, then click OK.
Specifying Margin Print Options

Page breaks

Select the cell below and to the right of where you want the page break.
Select Insert > Page Break.
Specifying Page Breaks

Page numbering, add a page number

Select File > Page Setup and click the Headers & Footers tab.
Enter page number and other formatting codes in the Header or Footer frame, then click OK.
Specifying Headers and Footers

Page numbering, choose the starting number

Select File > Page Setup and click the Page tab.
Choose values in the Page Numbering frame, then click OK.
Specifying Page Print Options

Page order

Select File > Page Setup and click the Sheet tab.
Choose values in the Page Order frame, then click OK.
Specifying Sheet Print Options

Paper size

Select File > Page Setup and click the Page tab.
Choose the paper size and click OK.
Specifying Page Print Options

Print area

Select the cells you want to appear on the printout.
Select File > Print Area > Set Print Area.
Specifying Print Areas

Print orientation

Select File > Page Setup and click the Page tab.
Choose Portrait or Landscape and click OK.
Specifying Page Print Options

Print titles

Select the row(s) or column(s) that should appear as print titles.
Select File > Print Titles > Set Print Titles.
Specifying Print Titles

Row and/or column headings, print or hide

Select File > Page Setup and click the Sheet tab.
Check or uncheck Row Heading and/or Column Heading, then click OK.
Specifying Sheet Print Options

Scaling

Select File > Page Setup and click the Page tab.
Choose values in the Scaling frame, then click OK.
Specifying Page Print Options

Print option	How to set that option	For more information
Black and white printing	Select File > Page Setup and click the Sheet tab. Check No Color, then click OK.	Specifying Sheet Print Options
Center the printout on the page	Select File > Page Setup and click the Margins tab. Choose values in the Center frame, then click OK.	Specifying Margin Print Options
Color printing	Select File > Page Setup and click the Sheet tab. Un-check No Color, then click OK.	Specifying Sheet Print Options
Footer	Select File > Page Setup and click the Headers & Footers tab. Enter codes in the Footer frame, then click OK.	Specifying Headers and Footers
Grid lines, print or hide	Select File > Page Setup and click the Sheet tab. Check or uncheck Grid Lines, then click OK.	Specifying Sheet Print Options
Header	Select File > Page Setup and click the Headers & Footers tab. Enter codes in the Header frame, then click OK.	Specifying Headers and Footers
Margins	Select File > Page Setup and click the Margins tab. Choose values in the Margins frame, then click OK.	Specifying Margin Print Options
Page breaks	Select the cell below and to the right of where you want the page break. Select Insert > Page Break.	Specifying Page Breaks
Page numbering, add a page number	Select File > Page Setup and click the Headers & Footers tab. Enter page number and other formatting codes in the Header or Footer frame, then click OK.	Specifying Headers and Footers
Page numbering, choose the starting number	Select File > Page Setup and click the Page tab. Choose values in the Page Numbering frame, then click OK.	Specifying Page Print Options
Page order	Select File > Page Setup and click the Sheet tab. Choose values in the Page Order frame, then click OK.	Specifying Sheet Print Options
Paper size	Select File > Page Setup and click the Page tab. Choose the paper size and click OK.	Specifying Page Print Options
Print area	Select the cells you want to appear on the printout. Select File > Print Area > Set Print Area.	Specifying Print Areas
Print orientation	Select File > Page Setup and click the Page tab. Choose Portrait or Landscape and click OK.	Specifying Page Print Options
Print titles	Select the row(s) or column(s) that should appear as print titles. Select File > Print Titles > Set Print Titles.	Specifying Print Titles
Row and/or column headings, print or hide	Select File > Page Setup and click the Sheet tab. Check or uncheck Row Heading and/or Column Heading, then click OK.	Specifying Sheet Print Options
Scaling	Select File > Page Setup and click the Page tab. Choose values in the Scaling frame, then click OK.	Specifying Page Print Options