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 …

In a PivotTable or PivotChart, you can expand or collapse to any level of data detail, and even for all levels of detail in one operation. On Windows and the Mac, you can also expand or …

On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the options you want. To make the columns in a table automatically fit the contents, select …

To expand an array formula, select the current formula, the new data, the blank cells next to the new data, edit the formula, and press Ctrl+Shift+Enter.

If you find yourself needing to expand or reduce Excel row widths and column heights, there are several ways to adjust them. If you're working in Page Layout view (View > Workbook Views > …

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.

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 …

A column of complex values, such as tables, lists, records or links, can be expanded to reveal the values contained in the complex value. In Microsoft Power Query for Excel, you use the …

To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list).

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.