Convert Ranges to a Table in Excel

Convert Ranges to a Table in Excel

 

 

 

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.