In the Data group, click on Change Data Source button and select “Change Data Source” from the popup menu. When the Change PivotTable Data Source window appears, change the Table/Range value to the new data source that you want for your pivot table and then click on the OK button.

How do I expand a pivot table field list?

Expand or Collapse the Pivot Field

  1. Right-click the pivot item, then click Expand/Collapse. In this example, I right-clicked on Boston, which is an item in the City field.
  2. Select on of the Expand/Collapse options: To see the details for all items in the selected pivot field, click Expand Entire Field.

How do you extend a range in Excel?

Resize an existing named range with Name Manager function

  1. Click Formulas > Name Manager.
  2. In the Name Manager dialog box, select the range name you want to resize it, and then click the button.
  3. In the Name Manager – Refers to box, select a new range for this range name, and then close this box.

How do you add expand in Excel?

To add collapsible Excel rows, simply select the rows you want to collapse and use the Outline feature under the Data tab to group them. You can then click the plus and minus symbols on the left to collapse and expand, or the numbers at the top to collapse all and expand all.

How do I expand a table in Excel?

Resize a table by adding or removing rows and columns

  1. Click anywhere in the table, and the Table Tools option appears.
  2. Click Design > Resize Table.
  3. Select the entire range of cells you want your table to include, starting with the upper-leftmost cell.
  4. When you’ve selected the range you want for your table, press OK.

How do you make an infinite range in Excel?

If you want to refer to a range starting from A2 until max row (1048576 or 65536 for Excel prior to 2007), you can use this volatile formula… =OFFSET(A2,0,0,(COUNTBLANK(A:A)+COUNTA(A:A)-1),1) . Use formula as a defined range name or inside other formula which takes range as an argument (for eq SUM)…

How do you change the range of a pivot table?

Answer:Select the Options tab from the toolbar at the top of the screen. In the Data group, click on Change Data Source button. When the Change PivotTable Data Source window appears, change the Table/Range value to reflect the new data source for your pivot table.

How to create a pivot table in Excel?

Click a cell in the source data or table range.

  • Go to Insert > PivotTable . If you’re using Excel for Mac 2011 and earlier, the PivotTable button is on the Data tab in the Analysis group.
  • Excel will display the Create PivotTable dialog with your range or table name selected. In this case, we’re using a table called “tbl
  • In the Choose where you want the PivotTable report to be placed section, select New Worksheet , or Existing Worksheet . For Existing Worksheet
  • Click OK , and Excel will create a blank PivotTable, and display the PivotTable Fields list.

    • How do I change a pivot table in Excel?

    Steps Open your pivot table Excel document. Go to the spreadsheet page that contains your data. Add or change your data. Go back to the pivot table tab. Select your pivot table. Click the Analyze tab. Click Change Data Source. Click Change Data Source…. Select your data. Click OK. Click Refresh.

    How to change Pivot Table data source and range?

    Click on any Cell in the Pivot Table and this will bring up “Design” and “Analyze” tabs in the top menu bar. Click on Analyze > Change Data Source > Change Data Source option in the drop-down menu. In Pivot Table Data Source dialogue box that appears, click in Table/Range box and click on the Worksheet containing new Source Data.