However, an Excel table is far more than a range of formatted data with headings. The most obvious difference is that the table is styled.
The screenshot below contrasts a regular range and the table format: However, the data in a tabular format is not a true 'table' unless you've specifically made it such.Įxcel table is a special object that works as a whole and allows you to manage the table's contents independently from the rest of the worksheet data. You might be under the impression that the data in your worksheet is already in a table simply because it's organized in rows and columns. Tables containing hundreds or even thousands of rows and columns can be instantly recalculated and totaled, sorted and filtered, updated with new information and reformatted, summarized with pivot tables and exported. In truth, this generic name covers a ton of useful features.
The tutorial explains the essentials of the table format, shows how to make a table in Excel and leverage its powerful features.Īt the surface, an Excel table just sounds like a way to organize data.
