Look Who it Was Random video

Excel - Table Formatting: Over 1000 Formatting Options! - Episode 934

570 views · Published 22 January 2009 · 3:03 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Table Formatting: Over 1000 Formatting Options!

Welcome back to the MrExcel netcast! In this video, we will be discussing a brand-new feature in Excel 2007 - Table Formatting. This feature is perfect for creating professional and easy-to-read reports, and it's something that has been requested by many users for a long time.

To access this feature, you can use the shortcut key of CONTROL+T or go to the HOME tab and click on the big icon called FORMAT AS TABLE. The advantage of using this feature is that you get to choose from a variety of formatting options, such as alternating colors for rows and columns. You can choose from 54 different styles, and when you consider the 20 different color schemes available, that's over 1000 different formatting options!

Once you have selected your desired formatting, Excel will automatically apply it to your data. And the best part is, this formatting is dynamic. So, if you add new rows or columns to your table, the formatting will adjust accordingly. This makes it a great tool for creating reports that need to be updated frequently.

In addition to the banded rows, you can also choose to have banded columns, which is a unique feature that is not commonly seen. And if you want to change the color scheme, you can easily do so by going to the PAGE LAYOUT tab and selecting a different theme. This will change the 6 colors used in the 54 formatting options.

Overall, the table formatting feature in Excel 2007 is a game-changer for creating professional and visually appealing reports. It's easy to use and offers a wide range of options to suit your needs. So, if you haven't tried it yet, I highly recommend giving it a go. Thank you for watching 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/


The every-other-row formatting becomes simple in Excel 2007 using the Table functionality. Choose from 54x20 formats in seconds. Episode 934 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Formatting Tables
(00:42) Advantages of using the feature
(00:56) Choosing formatting options
(01:17) Turning off banded rows
(02:11) Total number of formatting options
(02:37) 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:
Advantages of using Format as Table in Excel 2007
Applying themes to Excel tables
Choosing formatting options in Format as Table
Customizing colors in Format as Table
Dynamic formatting with Excel tables
Excel 2007 feature: Format as Table
Exploring the different styles and formats in Format as Table
How to use the Format as Table shortcut key (CONTROL+T)
MrExcel netcast video on Format as Table feature
Tips for setting up and managing Excel tables
Using banded rows and columns in Excel tables
YouTube tutorial on adding alternating row formatting in Excel


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

More from this channel