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.
-
Select a cell within your data.
-
Select Home > Format as Table.
-
Choose a style for your table.
-
In the Format as Table dialog box, set your cell range.
-
Mark if your table has headers.
-
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
Video: Create and format an Excel table
Total the data in an Excel table
Resize a table by adding or removing rows and columns
Filter data in a range or table
Using structured references with Excel tables
No comments:
Post a Comment