Rather than having to customize the color palette, Office 2007 offers 20 built-in color schemes. You can change the document theme in just a few clicks. Episode 529 shows you how.
This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!
This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!
Transcript of the video:
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Well, this week we've been talking about, how to change colors in Excel 2003 and luckily, this is something in an Excel 2007 has gotten much, much simpler in Excel 2007.
You just need to go to the page layout tab and in the page layout tab you can either use the themes.
Drop-down or the colors drop-down and when we choose the themes drop down.
You'll see that there's 20 different themes built into Excel and while we usually use the office theme.
You can easily switch to any other theme and you'll see that the colors used in the charts and the colors use throughout the spreadsheet automatically change.
The great thing about the themes in office 2007, is the Power Point, Word and Excel all have the same 20 themes.
So, if you create a few spreadsheet in Excel, overview document in Word and then a presentation in Power Point.
They'll all look like they have the same color scheme, same fonts, same effects and things like that.
So, we also see live preview working here as we just hover over the various themes.
We can see the chart behind the drop-down automatically change to the right colors.
So, while in Excel 2003 was rather difficult to come up with a different color scheme.
Here we have 20 different color schemes built into Excel 2007.
Very easy to go through and change the look and feel of your document with just a couple of clicks.
Hey! Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Well, this week we've been talking about, how to change colors in Excel 2003 and luckily, this is something in an Excel 2007 has gotten much, much simpler in Excel 2007.
You just need to go to the page layout tab and in the page layout tab you can either use the themes.
Drop-down or the colors drop-down and when we choose the themes drop down.
You'll see that there's 20 different themes built into Excel and while we usually use the office theme.
You can easily switch to any other theme and you'll see that the colors used in the charts and the colors use throughout the spreadsheet automatically change.
The great thing about the themes in office 2007, is the Power Point, Word and Excel all have the same 20 themes.
So, if you create a few spreadsheet in Excel, overview document in Word and then a presentation in Power Point.
They'll all look like they have the same color scheme, same fonts, same effects and things like that.
So, we also see live preview working here as we just hover over the various themes.
We can see the chart behind the drop-down automatically change to the right colors.
So, while in Excel 2003 was rather difficult to come up with a different color scheme.
Here we have 20 different color schemes built into Excel 2007.
Very easy to go through and change the look and feel of your document with just a couple of clicks.
Hey! Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
