Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel+training - excel pivot

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Excel 2003 - Pivot Table

excel+training - Excel 2003 - Pivot Table

ResolvedVersion Standard

Miss has attended:
Excel Advanced course

Excel 2003 - Pivot Table

How do I delete a column from a pivot table that gives the message cannot delete or insert into this pivotal table?

RE: Excel 2003 - Pivot Table

Hi
You cannot physically delete the column from the Pivot Table the only way to remove it is to drag the field name off the Pivot Table and it will be removed.

Hope this helps.

Excel tip:

Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.