Convert a Range to a Table in Microsoft Excel: MOOC
Microsoft Excel Massive Open Online Course
http://excelmooc.com/course/watch-Ran...
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.