How do I Copy Color Palettes Between Excel 2007 Workbooks?

Written by greg lindberg
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How do I Copy Color Palettes Between Excel 2007 Workbooks?
(Comstock Images/Comstock/Getty Images)

When you are working with specific data in the Microsoft Office Excel 2007 spreadsheet application, you can create workbooks that include several worksheet tabs to organise your data. You can then add a colour palette to all of the tabs and cells in the spreadsheets to meet your preferences. After you’ve established the colour palette for one of your workbooks, then you can copy the same palette to another Excel 2007 workbook.

Skill level:


  1. 1

    Open the Microsoft Excel 2007 workbook that has the colour palette that you want to copy to another workbook.

  2. 2

    Open or create the Excel 2007 workbook on your computer that you want to copy the palette to with the other workbook still open.

  3. 3

    Click on the “Microsoft Office” button from the top toolbar menu and then click on the “Excel Options” button from the bottom of the page.

  4. 4

    Click on the “Color” tab and then select the workbook you want to copy from in the “Copy colours from” box.

  5. 5

    Click the “OK” button to save your changes and return to the workbook.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.