ANSWER:

Explanation:

Adding tables to an Excel worksheet makes it super easy to add and remove data, rows and columns. I would say this is likely one of the biggest advantages to using a table. When you create a table, formatting, such as shading and borders, is automatically added as well. When deleting or inserting rows and columns, the table element keeps the formatting intact. For example, if you add data to the first empty row below the table, Excel automatically extends the formatting to the new row.

We will look at a couple examples in this lesson and learn how to add and remove data, insert and delete rows and columns and resize tables.

Quick Review

Before we get too far, let's quickly review how to APPLY the table element to existing worksheet data. This will give us an example table to work with as we continue through the lesson and give you a quick refresher on the steps.

The example worksheet is the sales results for Mac's MooTime Ice Cream. Mac owns five stores throughout California, and we have the sales NUMBERS for each location. The worksheet also details the sales numbers for each type of ice cream treat Mac that sells at his creamery: cones, SHAKES, malts, sundaes and smoothies. Let's format the worksheet as a table. Here are the steps.

Highlight the worksheet data to format as a table (you can select any cell of data and press #Control + A on your keyboard).

Go to the Home menu in the ribbon.

Look in the Styles grouping of commands.

Click on Format as Table.

Choose a table style from the gallery.

When the Format as Table dialogue box opens, CONFIRM My table has headers is selected.

Click OK.

Nicely done! This table will give us a good example to use as we continue with the lesson.

Table for example

example spreadsheet

Adding Data

Imagine Mac's business is doing very well. He has opened two more stores: Lake Tahoe and Las Vegas. We need to add the two stores and their sales numbers to the worksheet.

Now, if you had created a standard worksheet and manually formatted the data with color, shading and borders, every time you needed to add data you would need to reformat. But with tables, the formatting extends to the new rows and columns. Let's start by adding the two new locations, which will require adding two more columns.

Go to the first empty column at the right of the table.

Type the new column title or header (in our example, we will enter Las Vegas).

Press the Enter key on your keyboard (notice below how the table has been extended to include the formatting and the filter control for the new column).