Working with page breaks
You can change the look of a spreadsheet by specifying page breaks. There are two kinds of page breaks: soft page breaks and hard page breaks. Quattro Pro lets you view and find page breaks in spreadsheets. Page breaks display as solid blue lines.
Quattro Pro automatically creates soft page breaks at the bottom of each page, according to the page size. You can insert either horizontal or vertical hard page breaks to start a new page.
Quattro Pro lets you convert soft page breaks to hard page breaks and hard page breaks to soft page breaks. You can also delete a hard page break.
To view page breaks |  |
|
•
|
|
Click View
 Page breaks. |
To find page breaks | |
|
1.
|
|
Click Edit
Find breaks. |
|
2.
|
|
In the Break type area, choose a type of page break from the list box.
|
|
3.
|
|
In the Break classification area, choose a page break classification from the list box.
|
|
4.
|
|
Click Find next.
|
To insert hard page breaks | |
|
1.
|
|
Click the cell where you want to insert a page break.
|
|
2.
|
|
Click Insert
Page break Create. |
|
3.
|
|
Choose a break type from the Break type list box.
|
|
•
|
|
The page break is inserted before the cell you click.
|
|
•
|
|
You can create a horizontal page break by selecting a row and clicking Insert
Page break Create. |
|
•
|
|
You can also insert a hard page break by clicking where you want to insert a page break and pressing Ctrl + Enter. This only applies if you are not in edit mode.
|
To convert soft page breaks to hard page breaks | |
|
1.
|
|
Move the pointer over the displayed page break until it changes to a double arrow
 . |
|
2.
|
|
Right-click the page break, and click Set hard page break.
|
To convert hard page breaks to soft page breaks | |
|
1.
|
|
Move the pointer over the displayed page break until it changes to a double arrow
. |
|
2.
|
|
Right-click the page break, and click Remove hard page break.
|
To delete hard page breaks | |
|
1.
|
|
Click below or right of the page break.
|
|
2.
|
|
Click Insert
Page break Delete. |
|
•
|
|
You can also delete all page breaks by clicking Insert
Page break Delete all. |