Apply Excel's Insert command to add more table columns. Getty Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns.

Consider adding a new column of data if they’re available and will improve the resulting pivot table. For example, let’s say that you want to analyze sales information for your company.

To add rows to the end of a table, drag the small indicator in the bottom right corner of the table to add more rows and more adjacent columns, if desired. To add a row inside a table, click in a ...