Skip to main content

Kutools for Office ā€” One Suite. Five Tools. Get More Done.

How to insert or showing Power View in Excel?

Author Sun Last modified

Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. But do you know how to insert or showing Power View in Excel? In this article, I introduce how to show Power View in Microsoft Excel 2013 and 2016.

Show Power View in Excel 2013

Insert Power View in Excel 2016

Show Power View in Excel 2013

In Excel 2013, the Power View feature is under Insert group.

1. Enable Excel 2013, click Insert > Power View. See screenshot:
A screenshot showing Power View under the Insert tab in Excel 2013

2. Then a Microsoft Excel Add-ins dialog pops out to remind you to enable the Power View add-in, click Enable to go on. See screenshot:
A screenshot of the Microsoft Excel Add-ins dialog to enable Power View

Tip: there may be a remind above the new sheet, click Install Silverlight to install the Silverlight program on your computer, and then click Reload after installing to continue.
A screenshot showing a prompt to install Silverlight in Excel for Power View

Then the Power View tab has been displayed in the ribbon. See screenshot:
A screenshot showing the Power View tab displayed in the Ribbon

Insert Power View in Excel 2016

In Excel 2016, the Power View feature has been hidden, you need to go to the Options dialog to find and enable it.

1. Click File > Options. See screenshot:
A screenshot showing the File and Options menu in Excel 2016

2. In the Excel Options dialog, select Add-ins from the left pane, and choose COM Add-ins from the Manage drop down list, and click GO. See screenshot:
A screenshot of the Excel Options dialog to enable COM Add-ins

3. Check Microsoft Power View for Excel option, click OK to enable this add-in. See screenshot:
A screenshot showing the Microsoft Power View for Excel add-in option

4. Click File > Options to open the Excel Options dialog again.

5. In the Excel Options dialog, click Customize Ribbon in the left pane, and choose All Comments to find Power View from the below list, and go to right Main Tabs section, click New Group to create a group(Report) under Insert tab, click Add to add Power View to the new group. See screenshot:
A screenshot showing how to customize the Ribbon to add Power View in Excel 2016

6. Click OK to save the change.

7. Then click Insert > Power View to enable the Power View feature, click Install Silverlight to install the Silverlight program on your computer, and then click Reload to finish the Power View inserting. See screenshot:

A screenshot of Power View being enabled in Excel 2016
A screenshot showing the prompt to install Silverlight after inserting Power View in Excel 2016

Related Articles:

Best Office Productivity Tools

šŸ¤– Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functionsā€¦
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language ā€“ supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

All Kutools add-ins. One installer

Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.

Excel Word Outlook Tabs PowerPoint
  • All-in-one suite ā€” Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
  • One installer, one license ā€” set up in minutes (MSI-ready)
  • Works better together ā€” streamlined productivity across Office apps
  • 30-day full-featured trial ā€” no registration, no credit card
  • Best value ā€” save vs buying individual add-in