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!
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!
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.
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.
