How to unhide sheets in Excel with VBA

How to unhide sheets in Excel with VBA

You might want to hide or unhide certain sheets in a workbook for security reasons and there are several ways you can do this. In this article, we’re going to show you how to unhide sheets in Excel with VBA.   How to unhide sheets in Excel Worksheets are...
How to hide formulas in Excel using the Protect Sheet feature

How to hide formulas in Excel using the Protect Sheet feature

If you don’t want your users to see or be able to edit your formulas, you can lock, or hide them easily using Excel’s Protect Sheet feature. This allows you to prevent any edits to formulas, or hide them altogether behind an optional password protection....
How to use a wildcard in Excel formula

How to use a wildcard in Excel formula

Excel supports wildcard characters in formulas to find values that share a simple pattern. For example, if you are looking for a string with known ending or beginning, and unknown characters in the middle, you can use wildcard characters to tell Excel to look for all...
How to delete blank rows in Excel using Power Query

How to delete blank rows in Excel using Power Query

Getting rid of blank rows in your data can be cumbersome, especially when working with large data sets. To add to your problems, Excel uses blanks as limits for ranges when you add tables or sort data, or try to use shortcuts. There are various methods to do this, but...
How to remove blank rows in Excel using sorting

How to remove blank rows in Excel using sorting

Blank rows can be a not so small nuisance in data collection applications. In addition to making data management harder, an unorganized data set filled with blanks can mess with your calculations. Furthermore, Excel uses blanks as limits of ranges when you add a...
How to calculate standard deviation in Excel

How to calculate standard deviation in Excel

One of the fundamental operations of statistical analysis is calculating the standard deviation of a data set. In this article, we’re going to show you how to calculate standard deviation in Excel using the STDEV.S and STDEV.P functions. Syntax =STDEV.S( array...
How to calculate mean in Excel

How to calculate mean in Excel

Calculating the mean of numbers is one of staples of statistical analysis processes. In this article, we’re going to show you how to calculate mean in Excel using the AVERAGE formula. Syntax =AVERAGE( array of numbers ) Steps Begin by creating the formula...
How to stop excel from changing numbers to dates

How to stop excel from changing numbers to dates

Excel changes some numbers or strings to dates to be “user-friendly” and ease the date entering process. However, Excel does so without actually asking you, and ironically, there is no option to turn this off. In this article, we’re going to show you...
How to Disable Excel Automatic Calculations

How to Disable Excel Automatic Calculations

Welcome to our simple guide on making Excel run faster! Excel is a popular program used for all sorts of tasks, like organizing data and making calculations. But sometimes, when you have a lot of data or complex formulas, Excel can start to slow down. This can be a...