Convert an Excel data range to a table
Here are the steps to create a data table with headings, filters, structured references, and automatic expansion. We will explain in detail the starting position, setting values, completion confirmation, and how to review in case of problems.
Published · Updated · FaultNote editorial policy
Who this guide is for and what to prepare
- People using Microsoft Excel for the first time
- People who want to safely practice converting an Excel data range to a table
What you need
- Prepare continuous data with headings, excluding blank rows, merged cells, and subtotals.
Check preparation and starting position
Prepare continuous data with headings, excluding blank rows, merged cells, and subtotals.
Open and configure features
- Select a cell within the data range and press [Insert] > [Table]. Check the range in the dialog.
- If the first row is an item name, select [Use first row as table heading] and press [OK]. Change the name in [Table Design] to something like SalesData without spaces.
Complete and check results
- Enter new data directly below the last line and check whether the stripes and formulas are automatically expanded. Try sorting and filtering using the ▼ headings.
Fix the problem and exit safely
Table names are used in structured references, so do not change them carelessly during the process. Do not include merged cells or blank rows in the base table.
- To return to the normal range, select the table and select [Table Design] > [Convert to Range].
Limitations and requirements
- Table names are used in structured references, so do not change them carelessly during the process. Do not include merged cells or blank rows in the base table.
Frequently asked questions
What if you can't find the item you want in Microsoft Excel?
To return to the normal range, select the table and select [Table Design] > [Convert to Range].
What should I be especially careful about when converting an Excel table to a table?
Table names are used in structured references, so do not change them carelessly during the process. Do not include merged cells or blank rows in the base table.
Official sources and verification date
Sources checked: . Check the official sources below for changes to supported systems, plans and menus.