Ask Your Question

How to import cell styles from another spreadsheet?

asked 2015-05-29 12:34:56 +0200

alwayssummer gravatar image

updated 2015-09-27 19:22:06 +0200

Alex Kemp gravatar image

I've created some cell-styles in one of my spreadsheets that I would like to transfer over to a new spreadsheet. I can't find the way to do it.

I've found two help pages on this topic and both refer to elements of the UI in the Styles and Formatting window that don't seem to exist on my installation.

First step is to open the Styles and Formatting window, which works fine, but then in both cases there is a step to open a submenu which I can't accomplish on my installation.

  1. In Using Styles From Another Document or Template it says to "Click the arrow next to the New Style from Selection icon to open the submenu." Unfortunately I can find no such arrow.
  2. In another help page, Load Styles, we are told to "Click the New Style from Selection icon and keep the mouse button pressed. Choose Load Styles from the submenu." That also does not open any submenu.

I'm at a loss.

Version: running on Windows 8.1 x64 US English

edit retag flag offensive close merge delete


@JohnSUN To clarify: I can get the Styles and Formatting window to appear. The problem is that the steps mentioned above that say how to open a submenu to import styles don't work for me. Minor edits above to try to clarify in the original question.

alwayssummer gravatar imagealwayssummer ( 2015-05-29 14:01:31 +0200 )edit

In older versions (I last tested with 3.6) there worked a tool 'Style Catalogue' > 'Organiser' which may have been a remnant of StarOffice times. This tool was designed for what you are looking for. The dialogue mentioned was opened by Ctrl+F11. The key is still preset in V 4.4.3 but does not respond (I'm on Win 8.1). I don't know whether there is a bug or whether the tool was finally deprecated. For me what JohnSUN described works fine. We may import styles into our templates e.g. this way.

Lupp gravatar imageLupp ( 2015-05-30 10:53:03 +0200 )edit

The help texts quoted here may be valid for Writer. The appearance and the functionality of the 'Styles and Formatting' tool depend much on the software component (document class). Writer also is using Ctrl+F11.for another purpose.

Lupp gravatar imageLupp ( 2015-05-30 11:05:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-05-29 12:52:49 +0200

JohnSUN gravatar image

updated 2015-05-29 21:12:05 +0200

Just copy the cell with applied style and paste it into another document anywhere. The cell will be moved along with the style. Then this cell can be cleaned (deleted) - the style will remain in the workbook and will be available to format any cells.


or see this movie on YouTube

edit flag offensive delete link more


Best answer so far, though it can get a little cumbersome when working with many styles.

alwayssummer gravatar imagealwayssummer ( 2015-10-19 03:15:40 +0200 )edit

The steps in the question work for Writer. In Calc, copy and paste is ok as a workaround but the load styles feature would be better when there are many custom styles involved.

braconnot gravatar imagebraconnot ( 2017-02-10 15:43:33 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-29 12:34:56 +0200

Seen: 804 times

Last updated: May 29 '15