1. Position the cursor within a range of cells containing values, row and column headings. <br>2. Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <br> | 1. Position the cursor within a range of cells containing values, row and column headings. <br>2. Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <br> |