Excel Tricks with Tejraj

We have already learned about Inserting Shapes as well as Inserting Images in excel. Now, in this blog post we will learn about inserting images in shapes in excel. We will learn to insert an image (which is logo of our website “ Excel Tricks with Tejraj ”) into various shapes. First we will insert the shape in excel and then we will insert the logo into inserted shape. Insert Image in Oval Shape: First, click on “Insert” tab and then click on “Shapes” command. Once we click on “Shapes” command, we can see various shapes available in excel. Out of these, you can select any shape as per your choice. In this case, we want to select the “Oval” shape. If you are not aware about the names of these shapes, then you can just place the mouse cursor on any shape which will automatically show the name of that shape. Once we click on the “Oval” shape, the shape of mouse cursor will change from doctor symbol to plus symbol. As soon as the mouse cursor symbol changes to plus symbol, we can draw ...

In this blog post we will learn to Insert Shapes in excel. For this we have to click on “Insert” tab and under “Illustrations” group we can find a command “Shapes”.  Once we click on the “Shapes” command, we can see large variety of shapes which are available in excel will appear on our screen. These shapes are divided into 09 different categories: 1. Recently Used Shapes 2. Lines 3. Rectangles 4. Basic Shapes 5. Block Arrows 6. Equation Shapes 7. Flowchart 8. Stars and Banners 9. Callouts Recently Used Shapes : All the recently used shapes will appear in this category. If you are using only few shapes repetitively then you don’t need to search for those shapes in their individual category. You can easily find them in Recently Used Shapes. Lines : We can find various types of Lines, Arrows, and Connectors etc. under this category. Rectangles : We can find various types of Rectangles under this category. Basic Shapes : We can find various types of basic shapes like triangle, oval, ...

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