Skip to search results
PRODUCT
Office.com results
Video: Create an Excel table
Video Watch this video to learn how to quickly convert a range of data into an Excel table.
Excel 2010
Video: Introduction to Excel tables
Video Learn how to manage information in Excel tables, which make it easy to format data, sort, filter, add totals, and use formulas.
Excel 2010
Use calculated columns in an Excel table
Article Formulas you enter in Excel table columns automatically fill down to create calculated columns.
Excel 2010
Using structured references with Excel tables
Article Structured references make it much easier and more intuitive to work with table data when you are using formulas that reference a table– either portions of a ta...
Excel 2010
Create or delete an Excel table (previously a list) in a worksheet
Article When you create a table in an Excel 2010 worksheet, you can manage and analyze the data in that table independently of data outside the table.
Excel 2010
Use Excel tables to manage information
Training Learn how to use Excel tables to sort and filter data, get special table formatting, and see table formulas auto fill.
Excel 2010
Excel 2010 Step by Step Chapters
Article Sample chapters from the best-selling Excel 2010 book: Microsoft Excel 2010 Step by Step, which is a task-based, visual guide for Excel 2010. This book is for b...
Excel 2010
Quick start: Create an Excel table
Article Excel tables make it easy to automatically apply formatting, sort and filter data, add totals, and use formulas.
Excel 2010
Delete a table without losing the data or table formatting
Article To convert an Excel table back to a normal range of data, right-click the table, point to Table, and then click Convert to Range.
Excel 2010
Remove a table without losing the data or table format
Article In Excel Online, you can't change a table back to a normal range; you need the Excel desktop program.
Excel Online
Delete an Excel table in a worksheet
Article Learn how to clear data, formatting, or table functionality from a table in Excel.
Excel 2013
Create an Excel table in a worksheet
Article Learn about the many ways to create a table in an Excel worksheet.
Excel 2013
Use structured references in Excel table formulas
Article Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a tab...
Excel 2013
Use formulas in an Excel table
Article Formulas you enter in Excel table columns automatically fill down to create calculated columns.
Excel 2013
Remove a table without losing the data or table format
Article Convert a table back to a normal range but keep the alternate row shading of the table style you applied to your data.
Excel 2013
Quick start: Create an Excel table
Article Follow three easy steps to format your data as a table so that you can use the table tools to work with it.
Excel 2013
Didn't find what you were looking for?Search all of Office.com