Look Who it Was Random video

Excel - Table Formatting in Excel: Customize Your Tables with Thousands of Formats! - Episode 425

244 views · Published 24 September 2009 · 2:42 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Table Formatting in Excel: Customize Your Tables with Thousands of Formats!

Welcome to another episode of the MrExcel netcast! I'm Bill Jelen and today we're diving into the world of table formatting in Excel. With the release of Excel 2007 just 12 days away, it's the perfect time to explore all the new features and options available to us. In this video, we'll be focusing on the various table formatting options and how you can customize them to fit your needs.

First, let's talk about the accent colors in the Office Theme. When we choose the GreenBar option, we have 6 different accent colors to choose from. But did you know that by selecting a different built-in theme from the Page Layout ribbon, you can access 20 different color schemes, each with their own set of 6 accent colors? This allows you to give your document a completely new look with just a few clicks.

But what if the built-in Table Styles aren't enough for your needs? No problem! You can easily create your own custom Table Style by right-clicking on an existing style and choosing "Duplicate". This will create a brand new Table Quick Style that you can customize to your heart's content. For example, you can adjust the height of the First and Second Row Stripes to 2, giving your table a double high GreenBar effect. And if you find yourself using this style frequently, you can even set it as the default for all new tables you create.

With the combination of the 40+ built-in Table Styles and the 20 built-in themes, the possibilities for customizing your tables are endless. You can create your own unique styles with different row and column heights, making your data stand out and look professional with just a few clicks. So go ahead and experiment with the various options and see what works best for your data. Thanks for watching and be sure to tune in next time for more Excel tips and tricks from MrExcel!"

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 Table Formatting Options
(00:24) Choosing from 6 Accent Colors in Office Theme
(00:43) Using 20 Built-in Themes for New Color Schemes
(01:03) Creating a New Table Style by Duplicating Existing Style
(01:26) Customizing Every Element in the Table
(01:47) Setting Custom Style as Default for Future Tables
(02:00) Creating Personalized Table Styles with Various Heights
(02:17) 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:
Built-in Themes
Color schemes
Creating a new Table Style
Customizing table elements
Excel 2007 new version
GreenBar accent colors
Office Theme
Page Layout ribbon
Set default Table Style
Table Formatting options
Table functionality
Table Styles

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



Six accent colors x 7 options x 20 themes x your imagination leads to thousands of different formats that you can apply to a table with a single click. Episode 425 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

More from this channel