×
英语
很抱歉。本文没有你的语言版本。

创建表以及设置表格式

Create and format tables

You can create and format a table, to visually group and analyze data.

Note: Excel tables shouldn't be confused with the data tables that are part of a suite of What-If Analysis commands (Data Tools, on the Data tab). See Introduction to What-If Analysis for more information.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.
  1. Select a cell within your data.

  2. Select Home > Format as Table.

  3. Choose a style for your table.

  4. In the Format as Table dialog box, set your cell range.

  5. Mark if your table has headers.

  6. Select OK.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Overview of Excel tables

Video: Create and format an Excel table

Total the data in an Excel table

Format an Excel table

Resize a table by adding or removing rows and columns

Filter data in a range or table

Convert a table to a range

Using structured references with Excel tables

Excel table compatibility issues

Export an Excel table to SharePoint

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×