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
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

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




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Copying and moving styles

Occasionally you may want to copy a style from one spreadsheet to another, or between a spreadsheet and a template, instead of recreating it in the second spreadsheet. You can do this using the Template Management dialog.

  1. Click File > Templates > Organize.
  2. In the Template Management dialog, set the lists at the bottom to either Templates or Documents, as needed. The default is Templates on the left and Documents on the right.
  3. Image:Tip.png To copy styles from a file that is not open, click the File button. When you return to this dialog, both lists show the selected file as well as all the currently open documents.
  4. Open the folders and find the templates from and to which you want to copy. Double-click on the name of the template or document, and then double-click the Styles icon to show the list of individual styles.
  5. To copy a style, hold down the Ctrl key and drag the name of the style from one list to the other.
  6. Choosing to copy styles from a document, not a template.
  7. Repeat for each style you want to copy. If the receiving template or document has many styles, you may not see any change unless you scroll down in the list. When you are finished, click Close.
  8. Copying a style from one document to another.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

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