Excel - All about Effects in Excel's Themes - Rarely Documented Secrets - Episode 530
2,792 views · Published 4 August 2009 · 2:20 · Indexed 14 November 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: All about Effects in Excel's Themes - Rarely Documented Secrets. Welcome back to the MrExcel netcast where we continue our discussion on themes in Office 2007. In this video, we will focus on theme effects and how they can enhance the visual appeal of your documents. As we mentioned in our previous video, a theme is made up of colors, fonts, and effects. So let's dive into the world of theme effects and see how they work. To access the theme effects, we need to go to the Drawing Tools, Format tab. Here, you will find a palette of all the different built-in formats. Microsoft has classified these formats into three categories: simple, moderate, and intense. The simple effects are located in the top row, the moderate effects in the middle, and the intense effects at the bottom. You can also access the effects drop-down from the Page Layout tab. In the effects drop-down, you will notice that each thumbnail has three shapes: a circle, an arrow, and a rectangle. These shapes represent the different levels of intensity for the effects. The circle is for simple themes, the arrow for moderate themes, and the rectangle for intense themes. To give you a better understanding, we have three ovals here, each with a different level of intensity. As you hover over the various themes, you will see how the effects change for the moderate and intense styles. It's interesting to note that the effects chosen for each theme make sense. For example, the Civic theme has a dotted line for the simple styles, and the top oval changes to a dotted line when this theme is selected. In our next video, we will discuss how to create a custom theme in Excel. However, you will have to choose from one of the 20 built-in effects themes to build your custom theme. So make sure to check out our next video to learn more about creating custom themes. Thank you for watching, and we'll see you next time for another netcast from MrExcel. Don't forget to like, comment, and subscribe 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/ In Excel 2007, a theme is comprised of fonts, colors, and effects. Episode 530 helps to decode the information in the effects thumbnails. 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! Table of Contents: (00:00) Introduction to Themes in Office 2007 (00:22) Overview of Effects in Themes (00:49) How Effects are Classified (01:17) Examples of Simple, Moderate, and Intense Effects (01:49) Building a Custom Theme in Excel (02:01) 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: Applying effects to ovals in Office 2007 themes Building a custom theme in Excel using built-in Effects themes Difference between simple, moderate, and intense themes in Office 2007 Effects for different shapes in Office 2007 themes Examples of effects in different Office 2007 themes How to access the Drawing tools in Office 2007 How to change effects in Office 2007 themes MrExcel netcast: Next episode preview Next topic: Building a custom theme in Excel Overview of effects in Office 2007 themes Understanding effects in thumbnail previews of Office 2007 themes YouTube video on Microsoft Office 2007 themes Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152550/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919