Naming And Renaming Excel Tables

Sharing buttons:

excels table feature was added with the

2007 release of the product and to this

day remains one of the most

underutilized feature of the application

among the many benefits associated with

tables include dynamically resizing data

ranges using structured references to

write formulas and automatic formula

replication in this tip you will learn

how to create user-defined names for

your tables in Excel regardless of the

method you choose to create a table that

is from the home or insert tabs of the

ribbon with a keystroke shortcut or by

importing data from external data

sources Excel automatically assigns a

name to the tables you create the first

table you create in a workbook inherits

the name table 1 the second table you

create in a workbook inherits the name

table 2 and so on many users find these

default table names to be non

descriptive of the data contained in

their tables and if you use numerous

tables in a workbook potentially

confusing fortunately you can easily

rename a table and assign it a name that

makes it easier for all users of the

workbook to understand the nature of the

data contained in the table to rename a

table begin by clicking anywhere inside

the table then from the table tools

design contextual tab of the ribbon

click in the table name field on the far

left side of the ribbon having clicked

in the table name field simply type the

name you want for your table in this

example we're replacing the name of

table 1 with the new name sales while

you have great freedom when creating a

new table name there are a few

guidelines you must follow for those

familiar with the guidelines associated

with defined names the following list

should look familiar the first character

of the table name must be a letter

and underscore character or a backslash

you can use numbers and special

characters and a table name but they

cannot be the first character of the

table name likewise

you cannot have spaces in the table name

tip number two the length of the table

name must be 255 characters or fewer tip

number three the table name cannot be a

combination of letters and numbers that

could otherwise be a row and column

address for example a 100 cannot be a

table name because it is the address of

a cell in a worksheet and lastly tip

number 4

table names are not case-sensitive

tables are one of excels most powerful

features while this tip is not meant to

convey all of the usefulness of working

with tables you now know that if you

create a table in Excel you can assign

virtually any name you wish to this

dynamically resizing data range on

behalf of everyone at k2 enterprises

thanks for taking time to watch this

video tip for more information on the

training courses we offer please visit

our website at