Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

Open the Excel worksheet that contains your data table. Right-click a cell in the table column next to where you wish to insert the new column.

How to create an Excel table. 1. First, enter the field names in the columns across the top, ... Cells group, Insert or Delete buttons. JD Sartain / IDG Worldwide. Easily add new columns & rows.

Create a table and insert data . Now that you are aware of the basics of pivot tables, letâ s create one. In the example below, we have created a database for salespeople with relevant details ...

To create this PivotTable, click anywhere inside the data source Excel Table and then do the following: 1. ... (Region) header cell and choose Insert from the resulting submenu.