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
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
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 … Read more
Following are 4 different methods to find the Sum of first 50 natural numbers using Excel. Formula using SUM and SEQUENCE function The following formula will return the sum of numbers from 1 to 50. =SUM(SEQUENCE(50,1,1,1)) For the sum of first 75 numbers, =SUM(SEQUENCE(75,1,1,1)) Formula using SUMPRODUCT and ROW function Formula that combines SUMPRODUCT and … Read more
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 … Read more
In this blog post, I will show you 3 different ways to remove Macros from an Excel workbook. Saving the Workbook as XLSX file This is the easiest way to remove macros from an Excel workbook! XLS, XLSM, and XLSB are the only Excel file formats that can hold VBA projects or Macros. If you save an Excel … Read more