How to Add the Developer tab to Excel Ribbon

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…

How to find Spelling Mistakes in Excel

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…

Very Hidden Sheet in Excel

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…

Different methods to generate Random Values in Excel

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…