Excel Tips – Save Time in Formatting Raw Data Using “Table Styles”

I have attached Save Time In Formatting Your Excel Data – Free Illustration PDF on Table Styles.

Save Time in Formatting Raw Data Using “Table Styles”
Select your raw data.

Go to “Home” tab, under the “Styles” group, choose any style from the “Format As Table”

Excel Tips –  2012


Place a check mark under the option “My Table has headers”, click “OK”

Step 4:
Now you would have an extra tab on the ribbon called “Design”
Excel Tips – ReachHarry.Com 2012

Go to “Design” tab; activate “Total Row”, now you should have an extra row at the bottom of your table.

Go to the last row of any numeric column, click on the drop down, and choose the function which you want to perform on those numbers.

This table styles save a lot of time in formatting our table data and getting calculations in a button.

Source – ReachHarry.Com

Click Here To Download Excel Tips – Table Styles