Tables

Sorting Information in a Table Using Excel

Posted on April 23, 2015April 23, 2015 by Jeff Feiertag

To Sort Information in a Table:

Choose the dropdown arrow in the column you would like to Sort. A list of possible Sort Orders will be displayed.
Choose the appropriate Sort Order you would like to use.
Choose OK when you have chosen your Sort Order. Excel will display only the information in the Sort Order criteria you have established.

Filtering Information in a Table Using Excel

Posted on April 23, 2015 by Jeff Feiertag

To Filter Information in a Table:

Choose the dropdown arrow in the column you would like to Filter. A list of possible Filters will be displayed.
Choose the appropriate Filter(s) you would like to use.
Choose OK when you have chosen your filter(s). Excel will display only the information in the table that meets the Filter criteria you have established.

Inserting and Formatting a Table in a Word Document

Posted on April 23, 2015April 23, 2015 by Jeff Feiertag

To Insert and Format a Table:

Determine where you would like to place the table in your document
Choose the Insert tab on the Ribbon.
Choose Table. This will display a Table Grid.
Decide on the number of rows and columns you would like to have in your table. Your table will open in your Word document.
- A new tab Table Tools will now appear in your Ribbon
Choose Table Tools tab to change the borders, border size, shading, etc. for your table.