IOU Remove Field Settings For Free

Remove the column in Datasheet viewRight-click the header row of the column that you want to remove.Click Delete Field on the shortcut menu.Click Yes to confirm the deletion.Save your changes.

Deleted custom fields and their data are stored until your org permanently deletes them or 15 days has elapsed, whichever happens first. Until that time, you can restore the field and its data. For information on restoring deleted custom fields and relationships, see Manage Deleted Custom Fields.

If you right-click one of the sales revenue amounts shown in the pivot table and choose Value Field Settings from the shortcut menu that appears, Excel displays the Value Field Settings dialog box.For example, you can calculate average sales by selecting Average from the list box.

Using the Summarize Values By tab of the Data Field Settings dialog box, you can indicate whether the data item should be summed, counted, averaged, and so on, in the pivot table. By default, data items are summed. But you can also arithmetically manipulate data items in other ways.

Delete a calculated fieldClick the PivotTable.On the Options tab, in the Tools group, click Formulas, and then click Calculated Field.In the Name box, select the field that you want to delete.Click Delete.Click the field that contains the item that you want to delete.More items...

If you want to change multiple pivot table fields, you can change the function in the Value Fields Settings, just do the following steps: Step1: select one filed in your pivot table, and right click on it, and then choose Value Fields Settings from the dropdown menu list. And the Value Fields Settings dialog will open.

In the Calculations group, click Fields, Items and Sets (Click Formulas in Excel 2010). Click Calculated Item. From the drop-down list of formulas, select the formula you want to delete. Click the Delete button.