To format your data as a table in Excel, select the range of cells you want, go to the Home tab, select Format as Table from ...

Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.