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”
Step1:
Select your raw data.

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

Excel Tips –  2012

Step3:

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

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

Step6:
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