Search all of Office.com
 
Support / Excel / Excel 2007 Help and How-to / Worksheet and Excel table basics
 
 

Using Excel tables

Add or remove table rows and columns in an Excel table

Article After you create a Microsoft Office Excel table in your worksheet, you can easily add table rows and columns. You can quickly add a blank row at the end...

Convert an Excel table to a range of data

Article After you create a table in Microsoft Of fice Excel, you may not want to keep working with the table functionality that it comes with. Or you may want a...

Create or delete an Excel table in a worksheet

Article When you create a table (previously known as list) in a Microsoft Office Excel worksheet, you can manage and analyze the data in that table independently...

Create, edit, or remove a calculated column in an Excel table

Article In a Microsoft Office Excel table, you can quickly create a calculated column. A calculated column uses a single formula that adjusts for each row. It automatically...

Demo: Organize your data by using an Excel table

Article Watch this demo to learn how to summarize and emphasize related data in Excel 2007. Organize, sort, filter, and calculate your data any way you like.

Export an Excel table to a SharePoint list

Article After you create a Microsoft Office Excel table in a worksheet, you may want to make the table data available to other users on a Web site.

Manage information in tables in Excel 2007

Article Microsoft Office Excel 2007 Inside Out By Mark Dodge and Craig Stinson Mark Dodge is a former senior technical writer for the Microsoft Office User Assistance...

Microsoft Excel Blog: Tracking split costs

Article The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel...

Organize data into Excel 2007 tables

Article Microsoft Office Excel 2007 Step by Step By Curtis D. Frye Curtis D. Frye is a freelance author and Microsoft Office Excel Most Valuable Professional living...

Overview of Excel tables

Article To make managing and analyzing a group of related data easier, you can turn a range of cells into a Microsoft Office Excel table (previously known as...

Print an Excel table

Article If the data that you want to print is in a Microsoft Office Excel table, you can print just the Excel table. Click a cell within the table to activate the...

Refresh an Excel Table

Article After you export a Microsoft Office Excel table to a Windows SharePoint Services list and create a connection to that list, you can update the table data...

Select rows and columns in an Excel table

Article You can select cells and ranges in a table just like you would select them in a worksheet, but selecting table rows and columns is different from selecting...

Total the data in an Excel table

Article You can quickly total the data in a Microsoft Office Excel table by displaying a totals row at the end of the table and then by using the functions that...

Turn Excel table headers on or off

Article Show All Hide All When you create a Microsoft Office Excel table on a worksheet, table headers are automatically added and displayed by default. Table headers...

Unlink an Excel table from a SharePoint list

Article When you unlink a Microsoft Office Excel table that was exported to a custom list on a Windows SharePoint Services site, the connection to that Windows...

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...

What happened to Excel lists?

Article Excel lists have been renamed in Excel 207. Excel lists are now called Excel tables.

Working with Excel tables in Visual Basic for Applications (VBA)

Article By Jan Karel Pieterse, MVP If you frequently work with Excel tables, you may want to learn how you can work with them in Visual Basic for Applications ...