by Ilker | Oct 3, 2018 | Excel Macros, Excel Tips & Tricks
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 descending...
by Ilker | Sep 25, 2018 | Excel Macros, Excel Tips & Tricks
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...
by Ilker | Sep 25, 2018 | Excel Tips & Tricks
Number Formatting feature in Excel mainly allows you to change the appearance of cells without overwriting their contents. Currency formatting or highlighting colors are common examples. But that’s not all! You can also use this feature to hide the value of a...
by Ilker | Sep 25, 2018 | Excel Tips & Tricks
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....
by Ilker | Sep 25, 2018 | Excel Tips & Tricks
When you copying data from an external source, more often than not, you’ll get the entire data stuffed into a single column. This is rarely how you want to see data in Excel, as the whole point behind using spreadsheets is to be able to manipulate and analyze...
by Ilker | Sep 25, 2018 | Excel Tips & Tricks
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...
by Ilker | Sep 25, 2018 | Excel Tips & Tricks
Excel’s Find and Replace feature is a versatile tool that can help you find specific values in your workbook. You can capitalize on this feature by using wildcard characters to find values that share a similar pattern. If you know how your search value starts...
by Ilker | Sep 14, 2018 | Excel Tips & Tricks
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...
by Ilker | Sep 14, 2018 | Excel Tips & Tricks
Blank rows are a common problem especially when it is gathered by importing or inexperienced user entry. They can be hard to get rid of, and Excel uses blanks as limits of ranges when you use features like adding a table, sorting or filtering. In this article,...
