---
title: "How to create pivot tables in excel?"  
description: "How to create pivot tables in excel?"  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96520/how-to-create-pivot-tables-in-excel  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 1 minute  

---

# How to create pivot tables in excel?

How to create [pivot](https://www.mindstick.com/articles/1511/pivot-with-dynamic-columns-in-sql-server) [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) in excel?

## Answers

### Answer by Hitesh Vohra

![How to create pivot tables in excel?](https://answers.mindstick.com/questionanswer/14d932e7-bae4-4732-b083-79aa6eb4c524/images/15ec4028-47ca-4edd-b186-997c804a312a.jpeg)\

- A **PivotTable** is a powerful tool for calculating, summarising, and analysing data, allowing you to spot similarities, patterns, and trends.
- PivotTables behave differently depending on the platform on which you're running Excel.
- **In Excel for Windows, make a PivotTable.**
- Choose the cells from which you wish to make a PivotTable.
- **Select PivotTable from the Insert menu.**
- This will generate a PivotTable from a table or range that already exists.
- Choose where the PivotTable report will be displayed. Select New Worksheet to add the PivotTable to a new worksheet, or Existing Worksheet to add the PivotTable to an existing worksheet.
- **Select OK.**

\

**Read More: [How do you create dropdown lists in excel?](https://answers.mindstick.com/qa/96518/how-do-you-create-dropdown-lists-in-excel)**


---

Original Source: https://answers.mindstick.com/qa/96520/how-to-create-pivot-tables-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.