by Ilker | Jan 24, 2019 | Excel Tips & Tricks
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...
by Ilker | Jan 17, 2019 | Excel Tips & Tricks
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...
by Ilker | Jan 14, 2019 | Excel Tips & Tricks
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...
by Ilker | Jan 9, 2019 | Excel Tips & Tricks
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...
by Ilker | Jan 8, 2019 | Excel Tips & Tricks
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...
by Ilker | Dec 25, 2018 | Excel Tips & Tricks
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...
by Ilker | Dec 25, 2018 | Excel Tips & Tricks
Hidden named ranges can be tricky to find and work with. This article will guide you through how you can show named ranges that were hidden using VBA.How to show named ranges that were hiddenNamed ranges are objects in a workbook’s Names collection and they have...
by Ilker | Dec 21, 2018 | Excel Tips & Tricks
The degree symbol (°) typically indicates temperature measurement, the magnitude of angles in geometry, and diminished chords in music. However, standard keyboards don’t have a button for this useful symbol. In this article, we’re going to show you 4...
by Ilker | Dec 21, 2018 | Excel Tips & Tricks
A check mark is the universal character for confirmed tasks and is widely used in managing lists. Seeing how commonly it’s used in organizing ourselves, you would think that there should be a keystroke for this! In this article, we listed 5 methods you can use...