by Ilker | Jan 16, 2020 | Excel Tips & Tricks
Excel uses absolute references for named ranges by default. While absolute references can cover most scenarios, relative references in named ranges work as relative references do in formulas. This behavior can be useful in some scenarios, but can be a bit tricky! In...
by Ilker | Jan 10, 2020 | Excel Tips & Tricks
Named ranges have a property named “scope”. Usually, you do not need to adjust this property to use named ranges in Excel. On the other hand, it can become very useful if you have a number of sheets that are identical. The scope concept allows you to use...
by Ilker | Dec 31, 2019 | Excel Tips & Tricks
Managing and removing named ranges in Excel can be a challenging task, as you would have to do this one by one for each field. In this guide, we’re going to show you how to make Excel remove named range containing errors. Download Workbook Filtering named ranges with...
by Ilker | Jun 10, 2019 | Excel Macros, Excel Tips & Tricks
Named ranges are cells, ranges, tables, formulas, or constant values that are represented with meaningful names, that are tied to their workbook reference (i.e. A1, B23, A1:B23). Using named ranges make formulas easier to read and maintain. In this guide, we’re...
by Ilker | May 28, 2019 | Excel Tips & Tricks
A name in Excel is used for referencing a cell, range, formula, or constant value for easier and faster access to those references. These names are called named ranges in Excel. Using named ranges in your workbook models can save you time and increase your efficiency....
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 VBA Named 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 Adam | Jul 6, 2018 | Blog
Users of all levels have different feelings about Excel named ranges. Some find them cumbersome, while others use them religiously. In addition to allowing quick access to complex references, named ranges can make your formulas a lot easier to read and maintain. Once...