Question

How to copy styles from one open workbook file to another?

Answer 1

1. right click that style
2.a box will appear ,then click copy option
3. going to another workbook right click on any cell reference
4. paste option appear then click that option

Answer 2

Answer:

Explanation:

Step - 1 Open the workbook that contains the cells styles that you want to copy.

Step - 2 On the home tab, in the styles group, click the more button next to the cells styles box that contains preview of styles.

Step - 3 Click merge styles.

Step - 4 In the merge styles, dialog box, click the workbook that contains the styles that you want to copy then prevoke.