How to get the nice formatting of a table without turning your data into an actual table.
Formatting data as a table gives you nice banded rows and makes your data much easier to read and analyze.
Now you have beautifully formatted data without the potential burden of having it formatted as a table.
Before you ask why someone would want to do this instead of keeping the data as a table, it's because sometimes you don't want or need a table in your worksheet and having the added functionality can be annoying.
Download the Excel file that accompanies this tutorial to try this out yourself.