Copying and moving styles
Occasionally there is a fantastic style in one spreadsheet that you want to copy over to your current spreadsheet. You can do this using the Template Management window.
-
Select File > Template > Organize, The Template Management window (shown in Figure 111) opens.
-
By default, on the left is a list of available templates and on the right is a list of open documents. If you double-click on a template or a document, a Styles icon will appear under the name of the template or document.

-
Now double-click on the Styles icon. to list all of the styles in that document or template . Hold down the Ctrl key and click and drag the styles you want from one side to the other, one style at a time.
Caution

|
If you do not hold down the Ctrl key when dragging a style in step 3 above, the style will be moved from one place to the other. You must hold down Ctrl in oder to copy the style.
|