EXCEL TABLES PARTICIPATION PROJECT Housing Problem TOPICS COVERED

EXCEL: TABLES PARTICIPATION PROJECT Housing Problem

TOPICS COVERED • • Create and format tables Insert rows and/or columns Use the table total row Sort data

CREATE TABLE 1. Open the worksheet where you want to create the table. 2. Select the range of cells: – First way: in the Name box, type A 3: K 54, and then press Enter on your keyboard – Second way: click the first cell A 3, and drag the mouse to the last cell K 54 3. 4. 5. 6. 7. Open the Insert ribbon. Click the Table button. Select the My table has headers box. Click the OK button. If a warning appears, click Yes to convert the selection to a table.

FORMAT TABLE USING TABLE STYLE 1. Click anywhere inside the table you want to format. 2. Open the Design ribbon. 3. In the Table Styles section, click the drop-down arrow to expand all of the options. 4. Click on a style of your choice.

INSERT A NEW COLUMN • If the new column will be the rightmost in a table: 1. 2. Click in any cell in the rightmost existing table column. Right-click, choose Insert and then Table Columns to the Right. • If inserting a table column anywhere else: 1. 2. Click in any cell in the column immediately to the right of where the new one will go. Right-click, choose Insert and then Table Columns to the Left. • Otherwise: 1. 2. Click in any cell in the column immediately to the right of where the new one will go. Go to the Home ribbon, choose Insert and then Insert Sheet Columns.

TURN ON TOTAL ROW AND/OR FIRST COLUMN 1. Click anywhere inside the table where you want to add a total row or using First Column formatting. 2. Open the Design ribbon. 3. In Table Styles Options section: – Check Total Row to display a total row – Check First Column to turn on the First Column formatting option

USE TOTAL ROW 1. In the total row (always at the bottom of the table), click the cell where you wish to display the statistics. 2. Click the drop-down arrow to display the statistics function list. 3. Select the statistics function according to the instructions. – To not display any statistics in a column, choose the None option

SORT DATA 1. Click the drop-down arrow in the column header where you want to sort. 2. Click Sort A to Z or Sort Z to A according to the instructions. – Sort A to Z: ascending (smallest to biggest) – Sort Z to A: descending (biggest to smallest)