Instructions for naming Excel tables

By default, tables in Excel are named Table 1, Table2, Table 3,... but if you keep the names like this, it will be difficult to adjust and process the table. Therefore, users should change these fixed labels and name the Excel table, according to the instructions below.

How to name a table in Excel

Step 1:

First you enter the data as usual, then click on any cell in the table and click Format As Table and choose the design that suits the data table.

Instructions for naming Excel tables

You select the data area you want to draw a table and then click OK to execute.

Instructions for naming Excel tables

Step 2:

Continue clicking on the table and then click on Design and look down at the Properties group, you will see the Table Name item . Enter a new name for the table in this box.

Instructions for naming Excel tables

If you want to rename the table later, select any cell in the table, click the Design tab, and then re-enter a different name for the Table Name.

Or you click on the Formulas tab and then click on Name Manager to manage.

Instructions for naming Excel tables

Now you will see the names of the data tables, click on the named table and click Edit below.

Instructions for naming Excel tables

Finally, you enter a new name for the table.

Instructions for naming Excel tables

Rules for naming tables in Excel

  • Table names must begin with a letter, underscore (_), or forward slash (\).
  • The remaining characters in the table name must be letters, numbers, periods, or underscores.
  • A table cannot be named "C", "c", "R", or "r".
  • Table names cannot be cell references, such as A1 or $B$2.
  • Each table name in a spreadsheet must be unique.
  • Keep your table names as short as possible and clearly identify the contents of the table. Table names can be up to 255 characters long.
  • Table names cannot contain spaces. If a table name is made up of more than one word, use underscores or periods to separate the words.
Sign up and earn $1000 a day ⋙

Leave a Comment

How to update iPhone to the latest iOS version

How to update iPhone to the latest iOS version

Updating your iPhone software (iOS) is a good idea. Updates are available for free from Apple. They apply the latest features and security fixes to your iPhone. Here's how to update your iPhone to the latest version of iOS.

Instructions for limiting iPhone speaker volume

Instructions for limiting iPhone speaker volume

iOS 18.2 brings an option to limit iPhone speaker volume. Users can adjust how loud their iPhone speakers can play songs, videos, and other media.

Instructions to turn off File Explorer thumbnails Windows 11

Instructions to turn off File Explorer thumbnails Windows 11

Due to personal privacy or some other reason, many people want to turn off Windows 11 File Explorer thumbnails. Below are instructions to turn off Windows 11 File Explorer thumbnails.

How to reset iPhone to restore factory settings, any iPhone can do it

How to reset iPhone to restore factory settings, any iPhone can do it

Resetting your iPhone is the easiest way to reset your iPhone settings to their defaults. Resetting your iPhone can help you fix a few simple problems. Here are the steps to restore your iPhone to factory settings.

How to create AI radio on YouTube Music

How to create AI radio on YouTube Music

The YouTube Music app features Ask for Music, which helps create AI-powered radio based on each person's custom commands.

Basic guide to using Blooket - an application that creates learning games

Basic guide to using Blooket - an application that creates learning games

Blooket.com is known as an extremely useful educational support platform. Let's explore how to use Blooket through this article with Quantrimang.

Instructions to unpin default folders Windows 11

Instructions to unpin default folders Windows 11

Windows 11 File Explorer includes a number of default folders pinned to the sidebar. If you do not need to use them, you can completely unpin the default folders in File Explorer.

How to enable Notification Cooldown on Android 16

How to enable Notification Cooldown on Android 16

Notification Cooldown Android will gradually reduce the volume and vibration intensity of notifications when you receive too many notifications from the same app at once.

TFT Frost Team Season 12, TFT Frost Build

TFT Frost Team Season 12, TFT Frost Build

DTCL season 12's Iceborn is the most special race and its mechanism is somewhat similar to Sub-Zero in Mortal Kombat.

ScratchJR Maze Game Design Tutorial (Final Post)

ScratchJR Maze Game Design Tutorial (Final Post)

For projects or games in ScratchJR, the start and end screens play an important role in enhancing the completeness of the product.

Instructions for adjusting the size of the Windows 11 scroll bar

Instructions for adjusting the size of the Windows 11 scroll bar

The scroll bar on Windows 11 is compact in size, but many people want to change this size, enlarge the scroll bar to make it easier to see when needed.

How to collaborate on notes in FaceTime

How to collaborate on notes in FaceTime

FaceTime iOS 17 has a collaboration feature in notes to type notes together and track changes as someone types.

Windows 11 camera resolution configuration guide

Windows 11 camera resolution configuration guide

With Windows 11 build 27758 , Microsoft added advanced camera options so users can adjust basic camera configuration settings.

How to annotate screenshots using Snipping Tool

How to annotate screenshots using Snipping Tool

Snipping Tool also provides built-in tools for annotating computer screenshots. This tool allows you to mark and highlight important parts of the screenshot to convey the message you want.

How to view IP address on computer, view Win 10 IP address

How to view IP address on computer, view Win 10 IP address

Checking your computer's IP address will be necessary in many cases. If you want to know what your computer's IP address is, read this guide to see your computer's IP.