Define a name using the Define Name option.This tutorial will not only teach you how to create a named range in Excel, but will also show how to leverage this feature to make your formulas much easier to write, read, and re-use. The reason is that very few users understand the essence of Excel names. Names in Excel are a paradoxical thing: being one of the most useful features, they are often considered pointless or nerdy. You will also learn how to edit, filter and delete defined names in Excel. The tutorial explains what an Excel name is and shows how to define a name for a cell, range, constant or formula.
