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.