

Data Tables (or “Excel Tables”) were introduced in Excel 2007. They were supposed to simplify the work with data in Excel. But in the reality they often made it more difficult. For example, handling different formulas in the same column is not really possible. Fortunately, you can easily convert a Data Table into a normal range.
In a hurry? Click once on a cell in your data table, go to the table tools ribbon and click on “Convert to Range“.
Contents
First of all: We are not talking about the data table that are part of the What-If Analysis functions on the data ribbon. For the analyse function also called data table please refer to this article.
A data table (which is also called “Excel Table”) offers a structured way to organize your data. It has some advantages and disadvantages towards normal cell ranges:
Convert a data table (Excel table) to a normal cell range in Excel.
There are two necessary steps for changing your table to a normal range (the numbers are corresponding to the picture):
Please note that the formatting (for example the row background pattern) might be lost.
Hold on a second. Was this information helpful so far?
Why don't you subscribe to our monthly, free Excel newsletter?
Subscribe now! Your welcome gift: Our big 45 pages keyboard shortcuts package. In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Of course, I'm also on other networks:
Twitter: Follow @professorexcel
Facebook:
The right-click method for converting a data table to a normal cell range might be slightly faster.
The second method is even faster.
Inserting a data table is quite simple: Click no Insert and then on Table.
Is also not difficult to convert a normal table into a data table (or Excel table).
There is also a keyboard shortcut for inserting Excel tables: Press Ctrl + T on the keyboard.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.