One of the most annoying things about copying and pasting in Excel is when you try to copy and paste the results of Excel formulas. However, you won’t be able to drag-and-drop the fields.Whether you want to copy and paste individual cells, rows or columns, or entire sheets, the following 15 tricks will help you do it faster and more efficiently. If you change to Compact form, the blue borders are still visible when the pivot table is active.

You can use Tabular form, or Outline form, with the Classic PivotTable layout. When you change the setting to Classic PivotTable layout, the pivot table’s report layout automatically changes to Tabular form. You can use the same technique to drag fields into the pivot table layout from the PivotTable Field List, or drag field labels out of the pivot table layout.

When the pointer changes to a four-headed arrow, drag the field label to a different area.

Point to a field label in the pivot table layout.

You can now drag the pivot fields from the PivotTable Field List onto the worksheet, or drag the fields to a different part of the pivot table.

Click OK, to close the PivotTable Options dialog box.Īfter you change the setting, the pivot table on the worksheet shows a blue border around each region.

On the Display tab, add a check mark to Classic PivotTable Layout.

Right-click a cell in the pivot table, and click PivotTable Options.

If you’d like to drag the pivot fields onto the worksheet layout, you can change a setting in the pivot table options. In the screen shot below, if you try to drag the Promo field onto the pivot table, the cursor shows an X.

In Excel 2007, you can only move the fields to the areas in the PivotTable Field List. In Excel 2003, you could drag fields from the PivotTable Field List onto the pivot table layout on the worksheet.

Microsoft excel drag and drop cells