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…
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…
In Excel, there can be two types of hidden Worksheets. One is ‘hidden‘ and other one is ‘very hidden‘. The normal ‘hidden’ mode is known to most of the Excel users. But the ‘very hidden’ mode is less known and Advanced Excel users make use of this feature. Very Hidden Worksheets are often used to…
Following are 4 different methods to generate random numbers in Excel RAND Function The RAND function in Excel can be used to generate a random number between 0 and 1. The RAND function is a volatile function and will update every when the worksheet is recalculated. RANDBETWEEN Function The RANDBETWEEN function returns a random number…