And, click OK. Now, both of the components is not there in your formatting.

Its really hard to format your data every time when you present it to someone.

It would be great if you have an option which you can use to format your data without spending much time.

So, when it comes to Excel, you have an amazing option which can help you to format your data in no time.

In auto format, you have numbers of pre-designed formats which you can apply on your data instantly.

All you have to do just select a format and click OK to apply.

Quick Note: Its one of those Excel Tricks that can help to get better at Basic Excel Skills.

But, with the release of 2007 with ribbon this option is not available in any of the tabs.

So, to use it in the Excel versions like 2007, 2010, 2013, and 2016 you need to add it to your Excels quick access toolbar.

Its a one-time setup so you dont have to do it again and again.

Add Auto Format on Quick Access Toolbar To add auto format to your quick access toolbar please follow these steps.

First of all, go to your quick access toolbar and click on the small down arrow from the end point of the toolbar.

Once you click on it, it will open Customize the Quick Access Toolbar in excel options.

From here, click on Choose commands from drop-down and select Commands Not in the Ribbon.

After that, come to the list of commands you have right below this drop-down.

Click OK. Now, you have the auto format icon in your quick access toolbar.

How to use AUTO FORMAT Applying formats with auto format option is super simple.

Powerpoint 15.4 How Do I Turn Off Auto Format Download This File

Download this file from here to follow along and follow below steps to format the table.

Now, you have a window, where you have different data formats.

Once you click OK, it will instantly apply your chosen format on the data.

How To Modify a Format in Auto Format As I mentioned above, all the formats in the auto format are a combination of 6 different components.

And you can also add or remove these components from each format before applying it.

Lets say, you want to add formatting on below data table but without changing its font style and column width.

Powerpoint For Mac 15.4 How Do I Turn Off Auto Format