Create a Table

Once the data has been entered, it can be converted into a table. To make managing and analyzing a group of related data easier, you can turn a range of cells into a Microsoft Office Excel table (previously known as an Excel list). A table typically contains related data in a series of worksheet rows and columns that have been formatted as a table. By using the table features, you can then manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet.

How to create the table:

1. Highlight the range containing your data in the worksheet.
2. Click on the Home tab.
3. Click on the Format as Table option on the ribbon to open the drop down menu.
4. Choose the blue Table Style Medium 9 option to open the Format as Table dialog box.
5. While the dialog box is open, cells in your range on the worksheet should be surrounded by the animated border.
6. If the animated border surrounds the correct range of cells, click Ok in the Format as Table dialog box.
7. If the animated border does not surround the correct range of cells, highlight the correct range in the worksheet and then click Ok in the Format as Table dialog box.
8. The table should have the drop down arrows added beside each field name and the table rows should be formatted in alternating light and dark blue.

Note: Table functionality is not supported in shared workbooks so you cannot create a table in a shared workbook.

<ACTIVITY>

Format imported customers data as table

</ACTIVITY>