Microsoft Excel has a VBA interface and options related to that Programming interface are arranged in the Developer tab. But when you install Excel for the first time, you may not see the Developer tab in the Excel Ribbon. In this blog post, I will show you how to add the Developer tab or any … Read more
Until now, Excel doesn’t have a lookup function that is designed to return a picture or pictures. That means there is no straight forward method for Picture Lookup in Excel. In this Excel tip tutorial, I will show you how to do Picture Lookup using the existing features in Excel. I have the list of … Read more
In this blog post we will go through 3 different methods to create a Hyperlink to another Worksheet in Excel. Following is the data which we will be using to explain these methods. Given below is the Cost summary of a Highway Project and the Total cost is the consolidation of amounts from the Worksheets … Read more
This blog post is about two methods to spot the misspelled words in an Excel Worksheet. Following is data which we will be using to explain these methods. Spelling tool in Excel to find the misspelled words Select the cells containing data > go to the Review tab of the Excel ribbon > click on … Read more
This blog post is about 3 different methods to extract the decimal part of a Number. TRUNC function to extract the Decimal part of a Number The TRUNC function in Excel truncates a number to the given precision. The formula =TRUNC(4.159) will return 4. The following formula will extract the decimal part of the number … Read more
This blog post is about 5 methods to convert data in an Excel worksheet to a Picture. Copy and Paste as Picture Select the cells containing data > Right-click > Copy Right-click on the cell where you want to place the picture > Paste Special… > Select Picture (U) from the Other Paste Options And … Read more
This tutorial is about 7 different methods to Remove Duplicates in Excel. I will be using the following data to explain the different ways to get rid of the records that repeat multiple times. Remove Duplicates tool in Excel The Remove Duplicates feature in Excel is the most popular tool for removing duplicates and is … Read more
This blog post is about 4 different methods to Display Formulas in Excel. Following is the screenshot of the data used to explain the different ways for displaying formulas. Show Formulas button To display all those formulas used in a worksheet, go to the Formulas tab in the Excel ribbon and click on Show Formulas … Read more
In this tutorial, I will show you 5 different ways to Extract only Numbers from a list of Strings. Following is a Table containing Text as well as Numeric Values and we will be using this data for explaining the different methods. FILTER Function to extract Numbers The ISNUMBER function in Excel can be used … Read more
Changing the Column Width or Row Height automatically to fit the contents is called AutoFit in Excel. 4 different methods to AutoFit Rows and Columns in Excel are explained in this blog post and the following is the data used for explaining these methods. AutoFit Rows and Columns manually Select the entire Worksheet by clicking … Read more