Look Who it Was Random video

Excel - Change Colors with Ease | Explore 20 Built-in Themes & Live Preview Feature - Episode 529

554 views · Published 21 August 2009 · 1:56 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Change Colors with Ease | Explore 20 Built-in Themes & Live Preview Feature.

Welcome back to the MrExcel netcast! In this week's episode, we're diving into the world of Excel 2007 and exploring how to change colors in your spreadsheets. Luckily, this is a much simpler process in Excel 2007 compared to its predecessor, Excel 2003.

To change colors in Excel 2007, all you need to do is go to the Page Layout tab. From there, you can use either the Themes drop-down or the Colors drop-down. When you select the Themes drop-down, you'll see that there are 20 different themes built into Excel. While the default theme is usually the Office theme, you can easily switch to any other theme and see the colors in your charts and spreadsheets automatically change.

One of the great things about the themes in Office 2007 is that they are consistent across all Microsoft Office programs. This means that if you create a spreadsheet in Excel, a document in Word, and a presentation in PowerPoint, they will all have the same color scheme, fonts, and effects. This makes it easy to maintain a cohesive look and feel across all your documents.

In addition to the 20 pre-built themes, Excel 2007 also offers live preview, allowing you to see how your document will look with different themes without having to commit to any changes. Simply hover over the various themes and watch as the chart behind the drop-down automatically changes to the corresponding colors. This feature makes it even easier to find the perfect color scheme for your spreadsheet.

Gone are the days of struggling to come up with a different color scheme in Excel 2003. With 20 built-in themes and live preview, Excel 2007 makes it a breeze to change the look and feel of your documents with just a few clicks. Thanks for tuning in to this netcast from MrExcel, and we'll see you next time for more Excel tips and tricks!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Introduction to changing colors in Excel 2003 and Excel 2007
(00:23) Changing colors in Excel 2007 using the page layout tab
(00:38) Using the themes drop-down to switch between 20 different color schemes
(00:53) Benefits of using themes in Office 2007 for consistency across documents
(01:19) Live preview feature for easy color scheme selection
(01:31) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Changing colors in Excel charts
Consistent color scheme across Office applications
Customizing the look and feel of Excel documents
Easy color scheme changes in Excel 2007
Excel 2003 color change
Excel 2007 color change
Exploring different color schemes in Excel 2007
Live preview feature in Excel 2007
MrExcel netcast on changing colors in Excel
Page layout tab in Excel
Using themes in Excel
Utilizing the themes drop-down in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152579/


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!

More from this channel