Resources
How to alphabetize Excel tabs using VBA
Keeping your data and calculations on separate tabs is easy for an organized structure, but too many tabs in a workbook can become overwhelming quickly. In this article, we're going to show you how to alphabetize Excel worksheets in ascending or...
Create Tables and Manipulate Data in an Instant with Excel Flash Fill
Being able to create large data sets that follow a certain pattern in an instant truly is a miracle, that comes in the form of Autofill. Even without any in-depth knowledge of it, most Excel users benefit from it at some point during their tenures. Flash...
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...
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
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...
With Autofill Excel Shows Its Smarts and Saves You Time
Autofill is an essential feature that any Excel user must be constantly using as it saves tremendous amount of time when creating spreadsheets. The capabilities of this feature range from simple copy-paste tasks to automatically creating entire tables, or...
Data Validation: Excel Doing the Data Cleaning for You
One of the most versatile features of Excel that is data validation can validate user entries based on rules set by you. With this feature, you can impose strict rules on cells where users can’t enter any invalid data, or display warning messages to make...
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...
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...