Get instant live expert help on How do I range names in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
create range names based on the values in the range A2:B5
Solved by V. U. in 29 mins
create appropriate range names for cell b18 and b21 by selection, using the values in the left column
Solved by M. Y. in 11 mins
Use the range A18:E20 to create named ranges using the values in the left column as the names.
Solved by Z. A. in 20 mins
I have excel 2016 for Mac, and there is no Names Manager. How can I change the range for a name from workbook, to an individual sheet?
Solved by K. E. in 28 mins
we are getting this error message
excel found a problem with one or more formula references in this worksheet
check that the cell references, range names, defined names and links to other workbooks in your formulas are all correct
just not sure how to trouble shoot it as it doesn't show which cell is incorrect
Solved by I. U. in 11 mins