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!
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!
Transcript of the video:
Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen.
Well, all this week, we've been trying to solve Lisa's problem of how to add alternating rows of formatting so that way it makes the report easier to read, and what I've used so far this week are things that have been available to us in all versions of Excel, I mean, at least going back 10 years.
Today, I want to talk about a feature that's brand-new in Excel 2007.
I use the shortcut key of CONTROL+T but it's actually here on the HOME tab, big icon called FORMAT AS TABLE.
The advantage of using FORMAT AS TABLE, you actually get to choose which formatting you're going to use, and so we can come down here to some of the DARK formats and choose alternating red and light red, blue and light blue, green and light green.
So, let's maybe choose the…how about the orange?
We’ll go with the orange here.
It says WHERE IS THE DATA FOR YOUR TABLE?
Provided you have no blank rows and blank columns, that's going to get it correct, click OK, and you're in.
Now, it’s Here, we're on a brand new ribbon tab called TABLE TOOLS, DESIGN, and we can turn on or off the BANDED ROWS.
It's turned on by default based on what we selected but you can turn that off.
You can also do alternating columns, you know, which is something kind of interesting.
I don't see this as often but it's possible to do, and we have 54 styles to choose from here, from LIGHT to MEDIUM to DARK with different formats.
Now, it’s not just the 54.
It's actually 54*20 because if we would come back to the PAGE LAYOUT tab, there are THEMES here.
The THEMES have 20 different color patterns.
If you don't want to change your FONTS or EFFECTS, you can just come into the COLORS drop-down and choose a different color scheme.
These color schemes basically control the 6 colors that are used in the 54.
So, we can get all kinds of different options here.
Actually, 54*20, over a 1000 different formats when you consider that you can turn on and off the BANDED ROWS, on and off the BANDED COLUMNS.
It gets to be astronomical how many different options you have for setting this up.
So, using the table functionality back there in the HOME tab, FORMAT AS A TABLE, and again, just like yesterday, this format is dynamic.
As we add new rows, it automatically calculates and redoes the formatting.
Great way to go.
Great new feature in Excel 2007, FORMAT AS TABLE.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
Well, all this week, we've been trying to solve Lisa's problem of how to add alternating rows of formatting so that way it makes the report easier to read, and what I've used so far this week are things that have been available to us in all versions of Excel, I mean, at least going back 10 years.
Today, I want to talk about a feature that's brand-new in Excel 2007.
I use the shortcut key of CONTROL+T but it's actually here on the HOME tab, big icon called FORMAT AS TABLE.
The advantage of using FORMAT AS TABLE, you actually get to choose which formatting you're going to use, and so we can come down here to some of the DARK formats and choose alternating red and light red, blue and light blue, green and light green.
So, let's maybe choose the…how about the orange?
We’ll go with the orange here.
It says WHERE IS THE DATA FOR YOUR TABLE?
Provided you have no blank rows and blank columns, that's going to get it correct, click OK, and you're in.
Now, it’s Here, we're on a brand new ribbon tab called TABLE TOOLS, DESIGN, and we can turn on or off the BANDED ROWS.
It's turned on by default based on what we selected but you can turn that off.
You can also do alternating columns, you know, which is something kind of interesting.
I don't see this as often but it's possible to do, and we have 54 styles to choose from here, from LIGHT to MEDIUM to DARK with different formats.
Now, it’s not just the 54.
It's actually 54*20 because if we would come back to the PAGE LAYOUT tab, there are THEMES here.
The THEMES have 20 different color patterns.
If you don't want to change your FONTS or EFFECTS, you can just come into the COLORS drop-down and choose a different color scheme.
These color schemes basically control the 6 colors that are used in the 54.
So, we can get all kinds of different options here.
Actually, 54*20, over a 1000 different formats when you consider that you can turn on and off the BANDED ROWS, on and off the BANDED COLUMNS.
It gets to be astronomical how many different options you have for setting this up.
So, using the table functionality back there in the HOME tab, FORMAT AS A TABLE, and again, just like yesterday, this format is dynamic.
As we add new rows, it automatically calculates and redoes the formatting.
Great way to go.
Great new feature in Excel 2007, FORMAT AS TABLE.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
