Can I make a spin small table in Microsoft Excel 2007?
Can I make a spin small table in Microsoft Excel 2007?
To Insert a Pivot Table you need:-
Open Excel 2007 and navigate to the position where you want to insert the pivot table. This may be the similar sheet that includes your data or a novel worksheet. Press "Insert" situated along the ribbon, the "PivotTable" button and then "PivotTable" from the drop-down menu.
To change Your Pivot Table
Choose the data to be included in the pivot table. Decide "Select a table or range" and next input the table and variety or just underline the data from the worksheet. Instead, you can choose "Use an external data source" to contain data from MSN Money or another connection. Decide where you want to insert the pivot table by choose "New worksheet" or "Existing worksheet." The pivot table will emerge. Prefer the fields you wish to display in your table from the "PivotTable Field List."
Bookmarks