If you clicked a cell in your list before you started the PivotTable Wizard, Microsoft Excel has automatically detected a ...

If you clicked a cell in your list before you started the PivotTable Wizard, Microsoft Excel has automatically detected a source range for your PivotTable.To enter a range in the box, you can type the range, or select the range directly on your worksheet. If you need to move the dialog box out of your way temporarily, click Collapse Dialog {hbmp 708}.