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. Selected Range of Data
  2. From the HOME tab, in the Styles section, click Format as Table. Format as Table Option
  3. From the drop-down list, select a table style of your choice to apply. Table Style Options
  4. In the Format As Table dialog box, click OK. Format As Table Dialog Box
  5. Select the TABLE TOOLS DESIGN tab and in the Table Styles group, select the arrow to view more options, and then select Clear. Clear Option
  6. Save the workbook.
Next