Description
In this video I'll show you how to name a table in Microsoft Excel. Excel gives every new table a generic name like Table1, and giving it a clear name makes your formulas much easier to read, especially when your workbook has more than one table.
Timestamps:
Introduction: 0:00
Create a Table: 0:19
Rename the Table: 0:59
Use the Table Name in Formulas: 1:55
Conclusion: 2:25
Check out my website for other great tutorials about all kinds of technology: https://maxdalton.how/
Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join
#excel #microsoftexcel #exceltutorial #techtips #tutorial
Video Transcript:
Step 1. Open your Excel spreadsheet. For this example, I'm using a subscriber list for a comic book shop. If your data isn't already a table, click any cell in your data, and then press "Control" and "T" on your keyboard. The Create Table window opens, showing the range of your data and a default table name, like Table1.
Step 2. Make sure the "My table has headers" box is checked, and then click "OK." Your data becomes a formatted table. You can also type a name in the "What is the name of your table?" box before you click OK, but I'll show you how to rename a table that already exists.
Step 1. Click any cell inside the table. The "Table Design" tab appears at the top of the screen.
Step 2. Click the "Table Design" tab. The Table Name box is on the far left side of the ribbon, and it shows the current name, like Table1.
Step 3. Click in the Table Name box, delete the current name, and type a new one, like Subscribers.
Step 4. Press "Enter" on your keyboard. Your table is renamed.
Table names can't contain spaces, need to start with a letter or an underscore, and can't match a cell reference like A1. If you want to separate words, use an underscore, like Pull_List.
Now you can use the table name in your formulas. For example, typing =SUM(Subscribers[Issues per Month]) in an empty cell adds up the Issues per Month column, and it automatically includes new rows as you add them to the table. You can also rename a table later by clicking the "Formulas" tab, clicking "Defined Names," and then clicking "Name Manager." Any formulas that use the old name update automatically.