Excel Tricks with Tejraj

In this blog post we will learn to Insert Multiple Rows in excel based on cell value with the help of VBA Code. For this we have prepared dummy data as shown in below image. In this data we have listed few “Products”, their “Quantities” and their “Unit Price”. Now we want to insert multiple rows based on their “Quantities”. For example, “Product 1” has 04 quantities so we have to add 04 rows below the Product 1, “Product 2” has 02 quantities so we have to add 02 rows below the Product 2 and so on. To avoid wasting our time by manually inserting rows one by one, we can use VBA code which will do our work within seconds. To do this, just follow the below steps: 1. Add “Developer Tab” on the Ribbon if it is not already added. If you are not aware about how to add Developer Tab on the Ribbon then click here . Once added on the Ribbon, “Developer Tab” will looks like as highlighted with red in below image. 2. Now, click on the “Visual Basic” command as highlighted in below image. 3. Once ...

One of my friend asked me to provide dynamic way of converting binary numbers in to hexadecimal numbers. Though there is already a function available in excel BIN2HEX() but my friend requested me to provide some customization in it. I tried my level best and provided him a solution. We will learn to create same format through this blog post. YouTube Video: Just follow below easy steps and create your own template to convert binary numbers into hexadecimal numbers. 1. Under Developer tab click on Insert command ( Click here if developer tab is not visible on your ribbon ). 2. Click on Toggle button from the available buttons. 3. Draw a shape and you will see “Toggle Button” get appear on your screen. 4. Click on this toggle button and you will see “Format” tab will appear on your Ribbon . Under this tab adjust the height and width as below: Height: 1cm Widht: 1.65 cm 5. Toggle button will now look as shown in below image. 6. Right Click on the resized Toggle Button and click on “Proper...

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!!!