As a follow-up to yesterday's podcast, we'll take a look at how to customize the formatting used in the Excel 2007 table formatting. Episode 694 shows you how.
This blog is the video 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!
This blog is the video 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!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I am Bill Jelen.
yesterday, we took a look at how to use the table functionality.
To create a table with banded rows or green bar formatting.
I'm going to do that again.
I'm going to use Insert Table.
CTRL+T is the other way to define a table.
And you'll see that we have this whole gallery of different styles, but you're not limited to just these styles.
I'm going to choose one that's similar the blue.
I like the blue.
I'm going to right-click and say duplicate.
And now, I can change every element of formatting.
For example, if I want the rose to be to dark blue to light blue, I can change the Stripe Size from 1 to 2 or up to 9.
Second row stripe, make it to be 2.
Click OK.
And now, what I have.
You'll notice it didn't change the table.
But in the gallery, at the top I have something called Custom.
These are the ones that I've defined and if I want all of my future tables to have this style, I could right-click and say Set As Default.
Now, anytime that I created a table in the future, it will automatically have this formatting with the two row green bar.
I'm very easy to do.
The table functionality is fairly amazing and allows you to very easily format tables.
And enters, they used to require difficult conditional formatting .
I want to thank you for stopping by .
We'll see you next time for another netcast from MrExcel.
I am Bill Jelen.
yesterday, we took a look at how to use the table functionality.
To create a table with banded rows or green bar formatting.
I'm going to do that again.
I'm going to use Insert Table.
CTRL+T is the other way to define a table.
And you'll see that we have this whole gallery of different styles, but you're not limited to just these styles.
I'm going to choose one that's similar the blue.
I like the blue.
I'm going to right-click and say duplicate.
And now, I can change every element of formatting.
For example, if I want the rose to be to dark blue to light blue, I can change the Stripe Size from 1 to 2 or up to 9.
Second row stripe, make it to be 2.
Click OK.
And now, what I have.
You'll notice it didn't change the table.
But in the gallery, at the top I have something called Custom.
These are the ones that I've defined and if I want all of my future tables to have this style, I could right-click and say Set As Default.
Now, anytime that I created a table in the future, it will automatically have this formatting with the two row green bar.
I'm very easy to do.
The table functionality is fairly amazing and allows you to very easily format tables.
And enters, they used to require difficult conditional formatting .
I want to thank you for stopping by .
We'll see you next time for another netcast from MrExcel.
