Once you have selected any of the cells within the table, you will see a new tab appear on the ribbon, called Table Tools, Design.
Figure 10 shows you what the ribbon will look like after you click this tab.
This article introduces you into the concepts of working with Tables in Excel 2013, 20 and shows you how they may help you in your everyday Excel use. Of course you already have some data available somewhere on your sheet.
If you add rows to your table, any object that uses your table’s data will automatically include the new data.What these are exactly is beyond the scope of this article.Use this combobutton to refresh the external data in your table.Click on the button that says "Format as Table" (see figure 2): Figure 2: "Format as Table" button on the Styles group of the Home tab.After clicking this button, Excel shows a new user interface element called a gallery, with a number of formatting choices for your table, see figure 3: Figure 3: Table format gallery. After clicking one of the formats, Excel will ask you what range of cells you want to convert to a table (see figure 4).