How to compare two columns in Excel

How to compare two columns in Excel

Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods.Compare two columns...
How to wrap text in Excel

How to wrap text in Excel

By default, Excel will cut off the characters that don’t fit into a certain space. An alternative approach is wrapping the text to fully display it by increasing the cell height. In this guide, we’re going to show you how to wrap text in Excel. These methods...
How to use format painter in Excel

How to use format painter in Excel

The Format Painter is the life saver when you need to copy only the formatting settings from one section to the other in your spreadsheet. In this guide, we’re going to show you how to use format painter in Excel. The best part is, this feature is supported by pretty...
How to add a custom button to Excel Ribbon

How to add a custom button to Excel Ribbon

Ability to add a custom button helps you quick access to your macros or favorite actions directly from the Ribbon. The Ribbon was introduced in 2007 and made customizable with Excel 2010. So you can use this trick in all versions starting with 2010. This article shows...
What does double minus — do in Excel

What does double minus — do in Excel

The double minus, also known as double unary, is an operation to convert Boolean values into ones and zeroes. Simply; TRUE to one (1) and FALSE to zero (0). A unary operation is an operation with only one operand, which is in contrast to binary operations that use two...
How to hide named ranges using VBA

How to hide named ranges using VBA

You might want to hide the named ranges in your workbook to prevent your users to tamper with your calculations. In this article, we’re going to show you how to hide named ranges in Excel using VBA. How to hide named ranges using VBANamed ranges are objects in a...