How do you copy colour from one workbook to another in Excel 2007

[mosesg]

In Excel 2003 you could copy colours from one excel workbook to another using
the Tool, Options, Colour Tab and then selecting the workbook you want to
copy the colour from. I cannot find out how to do this in excel 2007, can
anyone help?

 

[John]

Hi
Have a look here for a interactive command reference guide
for Excel 2003 - 2007.
You can download it and have it on hand
http://www.microsoft.com/downloads/...7B3-9F90-93788112B985&displaylang=en#Overview

HTH
John

 

[1337]

Here is my own solution for restoring the original colors when copying certain highly formatted sheets or templates to a new spreadsheet.. it copies all data directly, so it only works if you need to copy a an entire sheet and restore the colors, not only apply colors to a different sheet with different data:

copy the original format workbook by ctrl + g and selecting the appropriate range

paste it into the new work sheet, colors will be all changed

with the destination still highlighted, right click and go to "Paste special" and select "All using source theme", then repeat the paste special, only with "Values" this time, and it should be identical to the original sheet you copied