Excel Tricks with Tejraj

In this blog post we will see how we can delete the rows in an excel sheet. There are various methods available in excel to delete the rows. Let’s learn them one by one: 1. Using Mouse Right Click 2. Using Delete Command 3. Using Keyboard Shortcut To learn these multiple methods to delete the rows in excel we will use the below dummy data which contains five rows “Row 1”, Row 2”, Row 3”, Row 4” and Row 5”. There are random numbers listed in each row. We will delete the “Row 3” from this data by using each of the above mentioned methods. Method 1: Using Mouse Right Click This is the first method which we will learn to delete the row. 1. Select the entire row which we wish to delete (in our case we have selected “Row 3”). 2. Press Mouse Right Click which will show several options on screen. Please select “Delete” option from this. 3. With this we can see that the data from “Row 3” is now deleted. Method 2: Using Delete Command This is the second method which we will learn to delete the c...

In this blog post we will learn about how we can hide and unhide sheet in excel. We have created 03 excel sheets named as “Sheet 1”, “Sheet 2” and “Sheet 3” to explain this topic in simple way. First we will learn multiple methods to hide an excel sheet and then we will learn to unhide the same sheet which we hide. Throughout this blog post we will consider “Sheet 2” as a selected sheet. It means out of 03 sheets which we have created, we will hide “Sheet 2” and later we will again unhide this same “Sheet 2”. Hide Sheet in Excel: Method 1: Using Format Command 1. Select the sheet which we wish to hide (In this case we have selected “Sheet 2”). 2. Go to “Home” tab and under “Cells” group, click on “Format” command and then select “Hide & Unhide” options out of list of appeared options and then select “Hide Sheet” option as shown in below image. 3. Once we click on “Hide Sheet” option, the sheet which we have selected will get hidden. Method 2: Using Mouse Right Click There is anothe...

In this blog post we will learn how to apply Icon Sets from Conditional Formatting to our data in excel. This Icon Sets will help us to improve visual presentation of our data.  Conditional Formatting option we can find in Home Tab under Styles group as shown in below image. If we click on Conditional Formatting then we can see multiple options available under this. Icon Sets is one of them. Click on this “Icon Sets” option to explore all the icons from this category.  All these icons are divided into 04 categories. 1. Directional 2. Shapes 3. Indicators 4. Ratings Then names of all the Icons from respective category are provided in below image. The sequence of the icons from image on the Left Hand Side is equal to the sequence of the names from the image from Right Hand Side. This will help you to select the proper icon sets when you are working in your daily tasks. We will now apply one-one icon set from each category on the below data. We have listed few numbers specificall...

In this blog post we will learn about Color Scales from Conditional Formatting. Conditional Formatting option is available in Home Tab under Styles Group as shown in below image. Click on the Conditional Formatting option and we will find Color Scale option as shown in below image. There are total 12 Color Scales option available in Excel. These 12 options are divided in 02 groups. Each group contains 06 options.  3 Color Scales  2 Color Scales  The names on all the 12 groups as per their group is listed below: 3 Color Scales: Green - Yellow - Red Color Scale Red - Yellow - Green Color Scale Green - White - Red Color Scale Red - White - Green Color Scale Blue - White - Red Color Scale Red - White - Blue Color Scale 02 Color Scales: White - Red Color Scale Red - White Color Scale Green - White Color Scale White - Green Color Scale Green - Yellow Color Scale Yellow - Green Color Scale We will now see how to apply these color scales options on the data in excel. For this we ...