Creating and Modifying a Table in Excel - Exercise

Contact Us or call 1-877-932-8228
Creating and Modifying a Table in Excel - Exercise

Creating and Modifying a Table in Excel

Duration: 5 to 10 minutes.

In this exercise, you will create an Excel table and modify it.

  1. Open the Sales - Table.xlsx file from your Excel2013.2/Exercises folder.
  2. Create a table that includes the data in all of the cells, using a style of your choice.
  3. Now, remove the style that you chose.

Solution:

  1. Select the cell range of the data, so from A1:D4.
  2. From the HOME tab, in the Styles section, click Format as Table.
  3. From the drop-down list, select a table style of your choice to apply.
  4. In the Format As Table dialog box, click OK.
  5. Select the TABLE TOOLS DESIGN tab and in the Table Styles group, select the arrow to view more options, and then select Clear.
  6. Save the workbook.
Next