answersLogoWhite

0


Best Answer

There are rules for naming ranges. The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters. You cannot use the uppercase and lowercase characters "C", "c", "R", or "r" as a defined name, because they are all used as a shorthand for selecting a row or column for the currently selected cell when you enter them in a Name or Go To text box. Names cannot be the same as a cell reference, such as Z$100 or R1C1 and cannot start with a cell reference. Spaces are not valid. A name can contain up to 255 characters. Names can contain uppercase and lowercase letters. Excel does not distinguish between uppercase and lowercase characters in names. For example, if you created the name Sales and then create another name called SALES in the same workbook, Excel prompts you to choose a unique name.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Which one of the following options is not a valid range name?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Which of the following is not a name of a valid chemical formula carbon chloride nitrogen monoxide copper II carbonate chloric acid?

carbon chloride is not a valid name for cny chemical


Is OWNPRG valid file name in dos?

Yes it is a valid name..


How can you name a valid name?

Changkuoth


What is a valid folder name?

COM


Where can someone find a local rifle range in Springfield Mo?

One can find local rifle range in Springfield MO from the following sources: Andy Dalton Shooting Range, Lucky Gunner, Springfield Rod and Gun, to name a few.


Can someone suggest the best domain name provider for me to create a website?

a valid domain name may not necessarily be valid as a hostname


What is the name of the baptism of the adult valid?

Anabaptist


What are the five rules or characteristics of valid variable name?

Valid variable names are different in different programming languages. In LabView (a front end for C): A valid variable name begins with a letter followed by a number of letters, digits, or underscores. The length of a valid variable name must be less than or equal to maxnamelen.


What is the birth name of Heidi Range?

Heidi Range's birth name is Heidi India Range.


Name the valid process for supporting a hypothesis?

Experimentation.


How do you use a name box to select a cell?

You can type in the cell reference, a cell range, a list of cells or a defined name into the Name Box. This will select the cell or cells specified. For example, you could type in any of the following: A3 A5:A10 A23,A45,A50:B20 If a cell range had been defined with the name Sales, you could type Sales into the Name box and it would select the cells specified. So for example you could type any of the following: Sales Sales, A3, B5:B20


How do you use the Name box to select a cell?

You can type in the cell reference, a cell range, a list of cells or a defined name into the Name Box. This will select the cell or cells specified. For example, you could type in any of the following: A3 A5:A10 A23,A45,A50:B20 If a cell range had been defined with the name Sales, you could type Sales into the Name box and it would select the cells specified. So for example you could type any of the following: Sales Sales, A3, B5:B20