Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

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:

  1. Navigate to the cell where the page break will begin.
  2. Select Insert > Manual Break.
  3. 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.

Image:Tip.png To see page break lines more easily on screen, you can change their color. Choose Tools > Options > OpenOffice.org > Appearance and scroll down to the Spreadsheet section.

Deleting a page break

To remove a page break:

  1. Navigate to a cell that is next to the break you want to remove.
  2. Select Edit > Delete Manual Break.
  3. Select Row Break or Column Break depending on your need.

The break is now removed.

Image:documentation_note.png 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, Column break may be grayed out.

In order to remove the break, you have to be in the cell next to the break. So, 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.


OpenOffice Calc 3.x Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Creative Commons License Design by Interspire