MrExcel's Learn Excel #418 - Table Formatting

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Sep 29, 2009.
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 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, we have 21 days until Excel 2007 debuts on January 30th 2007.
Today is an Excel 2007 Tuesday, so I want to talk about some of the new features in Excel 2007.
This week I'm going to spend a couple of episodes talking about the new table functionality in Excel.
If you think about most Excel worksheets, how many times do you have headers in your first row and then every row below that is another record and a data set?
Probably about 95% of my Excel spreadsheets follow that format.
Since this is such a common format, Excel has added new functionality, an intelligence called Tables.
To define a table, you can either select a single cell and hit Ctrl+T for table, or on the Home ribbon use the Format as Table gallery and choose some sort of formatting.
They have all different accent colors here, also different formatting.
So I'll choose this one, that kind of has the alternating row green bar format.
It asks where the table is, provided there are no blank rows or columns, it usually gets this address right.
Provided you have a header in every column, it predicts that your table has headers, I'll click OK.
And now the first thing apparent is: we have the green bar formatting.
And this green bar formatting is very intelligent.
if I insert new rows, it will automatically extend the green bar formatting properly.
So lots of times that were tricks to do this in Excel 2003, but once you insert a new rows, that green bar formatting never worked properly.
We also have automatically the auto filter dropdowns at the top, we can sort using the auto filter dropdown or see particular value.
So if we need to just see a couple of customers, we could uncheck (Select All) and see just the records for those particular customers.
Click OK and the auto filter works for us.
This is just the tip of the iceberg on tables.
On Thursday we'll talk about some more table functionality, that's there in Excel 2007.
Thanks for stopping by, we'll see you tomorrow for another netcast from MrExcel.
 

Forum statistics

Threads
1,213,560
Messages
6,114,309
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top