Select Table Design > Resize Table. Select the entire range of cells you want your table to include, starting with the upper-most cell. In the example shown below, the original table …

After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data.

Here's what you need to do. Select the range of cells that contains your current array formula, plus the empty cells next to the new data. Press F2. Now you can edit the formula. Replace …

To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet.

In this tutorial, you use Power Pivot to extend the Data Model, create hierarchies, and build calculated fields from existing data to create new relationships between tables.

PivotTable on iPad is gradually rolling out to customers running Excel on iPad version 2.80.1203.0 and above. In a PivotTable, press and hold an item you want to Expand or Collapse.

The spilled array formula you're attempting to enter will extend beyond the worksheet's range. Try again with a smaller range or array. In the following example, moving the formula to cell F1 will …

When you use Format as Table, Excel automatically converts your data range to a table. If you don't want to work with your data in a table, you can convert the table back to a regular range …

Select the fill handle at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Fill handles can be dragged up, down, or across a spreadsheet. Use the Fill command …

In a chart, click to select the category axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. This displays the Chart …