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 covers the range …

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 collapse to a …

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 your table.

How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

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 Expand operation to …

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 while …

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.

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.

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).

You can expand a column to match the size of the heading. However, that frequently means that you won't see as many columns on a page. When wrapping or vertically formatting text doesn't resolve …