After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table: Click anywhere in the table, and the Table Design tab appears. Select Table Design > Resize Table.

On the Home tab, select Format as Table, or expand the Table Styles gallery from the Table Design tab (the Table tab on a Mac). Select Clear. The table will be displayed in the default table format.

To make the columns in a table automatically fit the contents, select your table. On the Layout tab, in the Cell Size group, select AutoFit, and then select AutoFit Contents. To use the ruler, select a cell in the table, and then drag the markers on the ruler.

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 level of detail beyond the next level.

Adjust row and column size in tables when you need to fit text, make all rows or columns a uniform size, or simply make the table look how you want. Change column and row width. To change the width, do one of the following: Select the boundary of the column or row you want to move and drag it to the width or height you want.

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 > Page Layout ), you can specify a column width or row height in …

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 level of detail beyond the next level.

For example, you can expand the source data to include more rows of data. However, if the source data has been changed substantially—such as having more or fewer columns, consider creating a new PivotTable. You can change the data source of a PivotTable to a different Excel table or a cell range or change to a different external data source.

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 bring related tables back together.

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.