import color scheme from another excel (2007)

A

assenavant

hi,

in former versions of excel,
import color scheme from another excel: on the menu bar>tools>options>color
tab
in the "copy color from" box, click the down arrow and select the workbook
which contains the color schemes

but, for excel 2007?

thanx
 
G

Gary Brown

I don't have 2007 available here but I DO know that the 'tools>options'
selection can be found in 2007 at 'Office Button > Excel Options'.
Good luck.
 
J

Julie Giansante

For 2007, Click the Microsoft Office Button, and then click Excel Options.
Click on Save.

Under 'Preserve Visual Appearance of the workbook'
Click on Colors
Click on 'dropdown box' of Copy Colors from and select the file you want to copy the colors from and click OK.
Click OK to close the Excel Options dialog box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color lost when using two instances of Excel 1
Why does sheet formatting change when pasting into a new book? 0
Copying Color Scheme from Another Workbook 2
Paragraph numbering in Word 1
How to change custom color's tooltips from "Color Scheme"? 0
Excel 2007: How do I replace the default color table? 0
copy colors from another workbook? 0
Auto Color Scheme in Excel Charts 1

Top