Import cell styles from another workbook

When you create or change a style, the style is saved together with the workbook that it is in. You can import those cell styles from that workbook into another workbook.

  1. Open the workbook that contains the styles that you want to import.

  2. Open the workbook that you want to merge the styles into.

  3. On the Home tab, under Format, point to any style, and then click Lisää-alanuoli .

    Aloitus-välilehden Muotoile-ryhmä

  4. Click Import Cell Styles.

  5. Click the workbook that contains the styles that you want to import and merge, and then click OK.

  6. If the workbook that you are copying styles from has styles with the same names as the active workbook, you must select which version to use in the active workbook. Do one of the following:

To

Click

Overwrite the styles in the active workbook with the copied styles

Replace

Keep the styles in the active workbook as they are

Skip

Vihje: When you move or copy a sheet from one workbook to another, all the styles that are used on that sheet are also copied to that workbook.

See also

Move or copy a sheet

Apply, create, or remove a cell style

Kehitä taitojasi
Tutustu koulutusmateriaaliin
Saat uudet ominaisuudet ensimmäisten joukossa
Liity Office Insider -käyttäjiin

Oliko näistä tiedoista hyötyä?

Kiitos palautteesta!

Kiitos palautteestasi! Näyttää siltä, että Office-tukiedustajamme avusta voi olla sinulle hyötyä.

×