| Home : May 13 2016 Computer News : Excel pro tips: How to create, define, and use Named Ranges |
|
Excel pro tips: How to create, define, and use Named Ranges |
May 13, 2016
Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use those range names in your formulas or macros to replace values or cell references, or to quickly and more easily navigate through your spreadsheets and workbooks. It’s also a more efficient way to manage the various processes that you've created in your worksheets. For example, ranges are often named after the field (or column) names that define their contents.Create Range Names
1. Select a range of cells in your spreadsheet (for example, in our sample, select B4:B13).To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/3038788/software-productivity/excel-pro-tips-how-to-create-define-and-use-named-ranges.html#tk.rss_howto
|
|
|
|
|