Create an Excel table. On a worksheet, select the range of cells that you want to include in the table. The cells can be empty or can contain data. On the Home tab, in the Styles group, choose Format as Table, and then select the table style that you want.pply cell borders. Select the cell or range of cells that you want to add a border to. On the Home tab, in the Font group, click the arrow next to Borders, and then click the border style that you want. For more information about how to apply formatting to a worksheet, see Format a worksheet.