Here we have some data that is a good candidate for a table.
Each row represents an entry or record with information that belongs together.
Each column has a unique name.
The first step in creating a table is to remove any blank rows or columns.
Tables are designed to manage data in one contiguous block of cells.
Next, see to it column names are unique.
Excel will display the Create Table dialog.
The table range will be selected.
In most cases, you’ll want to check the checkbox for headers.
When I click OK, Excel creates the table.
If you first rename the columns yourself, you won’t have this problem.
after you grab a table, the first thing to check is the name.
Excel will automatically assign a generic name to new tables, starting with Table1.
You’ll see this name in the name box menu.
You’ll also see the name on the ribbon, under Table tools > Design.
Like named ranges, table names have certain restrictions.
For example, it’s possible for you to’t name a table “A1” or “Z100”.
Finally, names aren’t case sensitive.
Excel considers both names the same.
