MENU
Donate
=DIRECTORY.ENTRY
support.microsoft.com

Create and Format Tables

Microsoft guide to converting ranges into formatted Excel tables.

  • Sites
  • Free
Visit support.microsoft.com (opens in a new tab)

What it is

Turning a plain data range into a structured table unlocks automatic filtering, banding, and dynamic formula references that grow with your data. This official walkthrough covers how to create and style tables, adjust the header row, add total rows, and work with the sorting and filter tools that become available the moment you apply a table format.

At a glance

Source
support.microsoft.com
Type
Microsoft Excel sites
Category
Official Microsoft
Cost
Free

Also in Official Microsoft

All microsoft excel sites