![]() ![]() Consider how you can write the name using no spaces. Or, use an underscore character (_) or a period (.) as word separators. Use letters, numbers, periods, and underscore characters for the rest of the name.Įxceptions: You can’t use "C", "c", "R", or "r" for the name, because they’re already designated as a shortcut for selecting the column or row for the active cell when you enter them in the Name or Go To box.ĭon’t use cell references - Names can’t be the same as a cell reference, such as Z$100 or R1C1.ĭon’t use a space to separate words - Spaces cannot be used in the name. Use valid characters - Always begin a name with a letter, an underscore character (_), or a backslash (\). ![]() ![]() When you select any table from the list, Excel will automatically jump to that table-even if it's on another worksheet. All of your tables will be shown in the Address bar, which appears to the left of the Formula bar.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |