Tip:
Highlight text to annotate it
X
Convert a Range to a Table.
You can apply Excel's powerful table tools to any range by first converting that range
to a table. In Excel, a table is a collection of related information with an organizational
structure that makes it easy to add, edit, and sort data. A table is a type of database
where the data is organized into rows and columns: Each column represents a database
field, and each row represents a database record.
Click a cell within the range that you want to convert to a table.
Click the Insert tab.
Click Table.
Excel converts the range to a table.
Excel applies a table format to the range.
AutoFilter drop-down lists appear in each field heading.
Click the Tables Styles to see different styles for the table.