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 the Styles section, and choose the Table Style you prefer from the light, ...