Look Who it Was Random video

Excel Greenbar Formatting using Ctrl+T Tables - Episode 418

329 views · Published 29 September 2009 · 2:24 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Mastering Excel: Discover the Power of Tables for Organizing and Analyzing Data.

Welcome back to the MrExcel netcast, where we bring you the latest tips and tricks for mastering Excel. I'm Bill Jelen and today, we're diving into one of the new features in Excel 2007 - tables. With just 21 days left until the debut of Excel 2007 on January 30th, it's the perfect time to explore the new and improved functionality in this version.

Tables are a game-changer for anyone who frequently works with data in Excel. If you're like me, you probably have countless spreadsheets with headers in the first row and data in the rows below. Well, with tables, Excel has made it easier than ever to organize and analyze this type of data. Simply select a cell and hit Ctrl+T or use the Format as Table gallery on the Home ribbon to define your table. You can choose from a variety of formatting options, including the popular green bar format, which alternates row colors for easier readability.

But the real magic of tables lies in their intelligence. As you insert new rows or columns, the formatting will automatically adjust to include them. No more struggling to get your green bar formatting to work properly after adding new data. And that's not all - tables also come with built-in auto filter dropdowns, making it a breeze to sort and filter your data. Need to see only certain customers? Just uncheck the "Select All" option and choose the ones you want to view. It's that simple.

But wait, there's more! This is just the beginning when it comes to tables in Excel 2007. In our next episode, we'll explore even more functionality that will make your data analysis and organization tasks a breeze. Thanks for tuning in to today's netcast from MrExcel. Don't forget to join us tomorrow for another episode and be sure to subscribe to our channel for more Excel tips and tricks. See you soon!

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 Excel 2007 and new features
(00:22) Focus on new table functionality
(00:33) Defining a table and its benefits
(01:08) Automatic formatting and intelligent features
(01:38) Auto filter and sorting options
(01:55) More table functionality to be discussed in next episode
(02:05) 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:
Excel 2007 features
Filtering data in tables in Excel 2007
Formatting options for tables in Excel 2007
Green bar formatting in Excel 2007 tables
How to define a table in Excel 2007
Inserting new rows in a table in Excel 2007
More table functionality in Excel 2007
MrExcel netcast on Excel 2007 tables
Sorting data in tables in Excel 2007
Table functionality in Excel 2007
Tips for working with tables in Excel 2007
Using auto filter dropdowns in Excel 2007

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



Microsoft Excel 2007 adds new table intelligence that you can use in probably 90% of your worksheets. In Episode 418, learn how table functionality can easily apply greenbar formatting, autofilters, and more.

This blog is the video netcast companion to the upcoming book, Excel 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