Excel Tricks with Tejraj

In this blog post we will learn to customize SmartArt Graphic in excel. Previously we have seen to insert SmartArt Graphic in excel but in this post we will learn to customize them to give beautiful effects. If you are not familiar about how to insert SmartArt Graphic in excel then click here before reading this blog post. We will take same example which we have taken in our previous blog post about inserting SmartArt Graphic in excel. In that blog post, we have inserted below SmartArt Graphic. Where to find commands to Customize SmartArt Graphic on Excel Screen: The main thing we should know is where we can find commands to customize SmartArt Graphics on our excel screen ? For this we have to click on the SmartArt Graphic which we have created. Once we click on this SmartArt Graphic, two additional tabs as listed below will get enabled on Ribbon . 1. Design Tab 2. Format Tab We will use these two tabs to Customize SmartArt Graphic in excel. Note : These two tabs will get enabled if...

Ribbons are the most important part of excel or we can say it is heart of excel. But by default, there are only 07 Tabs visible on Ribbon . Now the questions is: how we can use other hidden options available on Ribbon? Let's find out with the help of this blog post "how to customize the Ribbon". YouTube Video As an example we will add Developer Tab to Customize the Ribbon. By default this Tab is not visible on the Ribbon . Following steps will help you to add this Tab on Ribbon: 1. Right click on the Ribbon 2. Select option “Customize the Ribbon” 3. New window named as “Excel Option” will appear. 4. Tick the checkbox in front of the “Developer” 5. Click on “OK” 6. Now you can see “Developer Tab” is added on the Ribbon .   Similarly you can add or remove desired Tabs or Commands and Customize the Ribbon. Its so simple!!!