Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel+training - Excel 2003 - Pivot Table

Resolved · Low Priority · Version Standard

Reply Wed 10 Oct 2007, 16:04Delegate Miss said...

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?

For upcoming training course dates see: Pricing & availability

Reply Thu 11 Oct 2007, 12:01Trainer Sandy said...

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 articles

· Create Contrasting Coloured Rows In Excel
· How To Learn From Your Excel Mistakes
· Simple Ways To Customise Excel
· How To Take Your Data Out Of The Shade
· Plug Into The Big Grid

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips