USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Drag it back from the Pivot fields into the field well
|
|
|
Right click the item in the field list and select Remove
|
|
|
Delete it from the source data, and then refresh the Pivot Table
|
|
|
Don’t know
|
Detailed explanation-1: -In a layout area, click the field that you want to remove, and then click Remove Field. In a layout area, click and hold the field that you want to remove, and then drag it outside the PivotTable Field List.
Detailed explanation-2: -Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click Analyze > Select, and then pick Entire PivotTable. Press Delete.
Detailed explanation-3: -Click Manual to rearrange items by dragging them. Hover the cursor over the item’s border until you see the four-pointed arrow, then drag. You can’t drag items that are shown in the Values area of the PivotTable Field List.
Detailed explanation-4: -Select the columns and/or rows containing the Pivot Table and press Delete on your keyboard.