Convert a Range into a Table

Turn plain data into a structured table with banding and filters.

You will learn to

  • Create a table from a range

How it works

Select your data and press Ctrl+T (Insert → Table). Tables add banded rows, filter buttons and expand automatically when you add data.