Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Page breaks"
(Using Page Break Preview for manual page breaks) |
(→Deleting a page break) |
||
| Line 34: | Line 34: | ||
The break is now removed. | The break is now removed. | ||
| − | {{Documentation/Note| Multiple manual row and column breaks can exist on the same page. When you want to remove them, you have to remove each one individually. This may be confusing at times, because although there may be a column break set on the page, when you go to '''Edit > Manual Break''', | + | {{Documentation/Note| Multiple manual row and column breaks can exist on the same page. When you want to remove them, you have to remove each one individually. This may be confusing at times, because although there may be a column break set on the page, when you go to '''Edit > Manual Break''', the column break may not be available (grayed out). |
| − | In order to remove the break, you have to be in the cell next to the break. | + | In order to remove the break, you have to be in the cell next to the break. For example, if you set the column break while you are in H15, you can not remove it if you are in cell D15. However, you can remove it from any cell in column H.}} |
=== Using Page Break Preview === | === Using Page Break Preview === | ||
Revision as of 20:55, 15 December 2010
Page breaks
While defining a print range can be a powerful tool, it may sometimes be necessary to manually tweak Calc’s printout. To do this, you can use a manual break. A manual break helps to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.
Inserting a page break
To insert a page break:
- Navigate to the cell where the page break will begin.
- Select Insert > Manual Break.
- Select Row Break or Column Break depending on your need.
The break is now set.
Row break
Selecting Row Break creates a page break above the selected cell. For example, if the active cell is H15, then the break is created between rows 14 and 15.
Column break
Selecting Column Break creates a page break to the left of the selected cell. For example, if the active cell is H15, then the break is created between columns G and H.
Deleting a page break
To remove a page break:
- Navigate to a cell that is next to the break you want to remove.
- Select Edit > Delete Manual Break.
- Select Row Break or Column Break depending on your need.
The break is now removed.
Using Page Break Preview
Use the menu View to toggle between Normal and Page Break Preview. The Page Break Preview gives you an easy way to manage manual page breaks. Insert Row Break or Insert Column Break in the context menu inserts a break above the actual cell or left of the cell respectively. The context menu has got the item Delete all manual breaks to get rid of them all at once. For changing a break, you need only to drag the break line with the mouse. Dragging it out of the sheet, will remove this single break. All actions affect only the active sheet.
Headers and footers are predefined pieces of text that are printed at the top or bottom of a sheet outside of the sheet area. They are set the same way.
Headers and footers are assigned to a page style. You can define more than one page style for a spreadsheet and assign different page styles to different sheets. For more about page styles, see Chapter 10.
To set a header or footer:
- Navigate to the sheet that you want to set the header or footer for. Select Format > Page.
- Select the Header (or Footer) tab.
- Select the Header on option.
From here you can also set the margins, the spacing, and height for the header or footer. You can check the AutoFit height box to have the height of the header or footer automatically adjust.
Margin
Changing the size of the left or right margin adjusts how far the header or footer is from the side of the page.
Spacing
Spacing affects how far above or below the sheet the header or footer will print. So, if spacing is set to 1.00", then there will be 1 inch between the header or footer and the sheet.
Height
Height affects how big the header or footer will be.
To change the appearance of the header or footer, click More.
From this dialog you can set the background and border of the header or footer. See Chapter 10 (Using Styles in Calc) for more information.
The header or footer of a Calc spreadsheet has three columns for text. Each column can have different contents.
To set the contents of the header or footer, click the Edit button in the header or footer dialog shown below to display the dialog shown below.
Areas
Each area is independent and can have different information in it.
Header
You can select from several preset choices in the Header drop-down list, or specify a custom header using the buttons below. (If you are formatting a footer, the choices are the same.)
Custom header
Click in the area (Left, Center, Right) that you want to customize, then use the buttons to add elements or change text attributes.
Opens the Text Attributes dialog.
Inserts the total number of pages.
Inserts the File Name field.
Inserts the Date field.
Inserts the Sheet Name field.
Inserts the Time field.
Inserts the current page number.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
