Course Content

Course Content


  • Select the PivotTable from the drop-down menu.
  • In the Tools category of the Options tab, choose Formulas, then Calculated Field.
  • Select the field you want to delete in the Name box.
  • Select Delete
  • Select the field containing the item you wish to remove.

Calculated fields and objects can be readily removed from an Excel pivot table. Click a cell in the pivot table to remove a calculated field. Then, from the Fields, Items & Sets command on the Analyze tab, select Calculated Field from the submenu that opens.

Calculated columns in Excel tables are a great way to quickly enter formulas. They let you to enter a single formula in a single cell, which will then spread throughout the rest of the column on its own. The Fill and Copy commands aren't required.

To begin, choose a cell inside the column to which you wish to add your formulas. It makes no difference which row you select as long as it is not the header row. If the new column is adjacent to the table, you do not need to alter it. Excel will automatically extend the table.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere