It was very simple in the previous version, where we just need to click on Tools > Options > Color tab > Copy colors from. I am here to figure out if this feature is there in Microsoft Office 2007. Copy cell styles from another workbook doesn't seem to work, nor does the Excel options Advanced tab.
Bookmarks