How to define names in Excel (tables)

Discover shortcuts to create Excel tables and rename them; learn how to define selections and name them. Use structured references in Excel formulas to save time!

Did you know you could define names in Excel for tables, worksheets, workbooks… and cells?

Naming a table can save you time when entering formulas in Microsoft Excel. Also, it reduces the risk of errors when you work with large tables.

In this free tutorial, learn how to rename tables and how to define names in general in Excel. Discover handy Excel shortcuts and how to use table references in formulas.

Are you ready to level up?

In MS Excel, define names with the Define Name tool and modify them with Name Manager.

Naming an element in Excel, giving it a reference, helps you finding information more easily and quicker. For example, instead of using cell ranges in formulas, you could use the name of these selections.

This technique reduces the risk of errors when using cells in complex formulas.

To define the name of an element in Excel, select the element to name then press Control+L keys.

For example, let name the range D10:D11 invoices_eu” because these cells correspond to the invoices sent the Europe.

Select cells D10 and D11 then press Control+L: a window appears.

Just type the name in the name field and click OK.

You can also click Define Name (circled in white) under the Formulas tab instead of the shortcut.

To rename a reference (cells for example), go to Formulas then click Name Manager. You can create new names, edit some or delete them.

Note that the name we just created (“invoices_eu”) now appears in the list.

Let focus on Excel tables now: learn how to create one almost instantly using a shortcut and how to rename it easily.

To create an Excel table, select your data then press Command+T.

For more information on how to design and (un)format tables in Excel, check this tutorial.

By default, the system names your table “Tablex” with x corresponding to a number. You first table will be named “Table1”, etc.

To rename a table, go to Name Manager (as mentioned previously) or enter the new name of your table directly under Table Name (Table tab).

Now that you know how to define names in Excel, learn how to use structured references in formulas.

A structured reference, in Excel, is the combination of table and column names. Instead of using cells references in a formula, you can use structured references (name of your table for example) to save time and avoid errors.

For example, sum all the invoices in the table named “Invoicing” by entering the formula =SUM(Invoicing[Invoices])

Invoicing = the name of the table
Invoices = the name of a column in this table

Remember the first selection we named “invoices_eu”?

We can use this reference in a formula too!

Instead of entering =SUM(D10+D11), enter =SUM(invoices_eu) to save time.

Tip: you don’t need to enter the full name of a reference because the system will show it as soon as it recognises the beginning of the name. Just click the name then continue entering your formula.

Now, you know how to define names in Excel, how to rename tables and how to use structured references in formulas thanks to Ted Jordan.

Join our Online Excel Course to level up and get certified.

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More
Cope Paste Options on excel with shortcut keys

Copy paste values like a pro! (Excel+Google Sheets)

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now...

Read More