Insert Tab


Tables

PivotTable - (Changed in 2013). Displays the "Create PivotTable" dialog box. In 2010 there was a button with drop-down. The drop-down contained the commands: PivotTable and PivotChart. The PivotTable displayed the "Create PivotTable" dialog box and the PivotChart displayed the "Create PivotTable and PivotChart" dialog box.
Recommended PivotTables - (Added in 2013). Displays the "Recommended PivotTables" dialog box. This shows a list of customised pivot tables that are best for your data. If there are no recommendations then a blank pivot table is created.
Table - (Ctrl + T). Displays the "Create Table" dialog box. When you define your data as a table it makes it easier to sort, filter and apply formatting.


Illustrations

Pictures - Displays the "Insert Picture" dialog box allowing you to browse to a file.
Online Pictures - (Added in 2013). Find and insert pictures from a variety of online sources.
Shapes - Drop-Down. The drop-down contains the commands: Recently Used Shapes, Lines, Rectangles, Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners and Callouts.
Icons - (Added in ??). Displays the "Insert Icons" dialog box. Insert an icon to visually communicate using symbols.
3D Models - (Added in ??). Drop-Down. Insert a 3D model so you can rotate it and see it from all angles. The drop-down contains the commands: From a File and From Online Sources.
SmartArt - Displays the "Choose a SmartArt Graphic" dialog box which lets you choose from the following different types of smartart: List, Process, Cycle, Hierarchy, Relationship, Matrix, Pyramid, Picture and Office.com (Added in 2010 but removed in 2016).
Screenshot - (Added in 2010). Drop-Down. The drop-down contains the commands: Available Windows and Screen Clipping.
Clip Art - (Removed in 2013). Toggles the display of the Clip Art task pane to let you insert drawings, movies, sounds, photos etc.


Add-ins

Get Add-ins - (Added in 2016). Displays the Office Add-ins window allowing you to see all the add-ins in the Office store.
My Add-ins - (Added in 2016). Button with Drop-Down. Displays the Office Add-ins window showing you all the add-ins you have currently installed.
Store - (Removed in 2016). (Added in 2013). Renamed to Get Add-ins in 2016.
My Apps - (Removed in 2016). (Added in 2013). Renamed to My Add-ins in 2016.


Charts

You can quickly display the "Insert Chart" dialog box by selecting your data and clicking on the dialog box launcher in the bottom right corner of the group. If a chart is active the "Change Chart Type" dialog is displayed.

Recommended Charts - (Added in 2013). Displays the "Insert Chart" dialog box (Recommended Charts tab).
Column or Bar - Drop-Down. The drop-down contains the commands: 2-D Column, 3-D Column, 2-D Bar, 3-D Bar and More Column Charts.
Line or Area - Drop-Down. The drop-down contains the commands: 2-D Line, 3-D Line, 2-D Area, 3-D Area and More Line Charts.
Pie or Doughnut - Drop-Down. The drop-down contains the commands: 2-D Pie, 3-D Pie, Doughnut and More Pie Charts.
Hierarchy - (Added in 2016). Drop-Down. The drop-down contains the commands: Treemap, Sunburst and More Hierarchy Charts.
Statistic - (Added in 2016). Drop-Down. The drop-down contains the commands: Histogram, Box and Whisker and More Statistical Charts.
Scatter XY or Bubble - Drop-Down. The drop-down contains the commands: Scatter, Bubble and More Scatter Charts.
Waterfall or Stock - (Added in 2013). This drop-down contains the commands: Waterfall (Added in 2016), Funnel, Stock, Surface, Radar and More Stock Charts.
Combo - (Added in 2013). The drop-down contains the commands: Combo and Create Custom Combo Chart.
Maps - (Added in 2017). Drop-Down. The drop-down contains the commands: Filled Map and More Map Options.
PivotChart - (Added in 2013). Button with Drop-Down. The button displays the "Create PivotChart" dialog box. The drop-down contains the commands: PivotChart and PivotChart and PivotTable.
Surface or Radar - (Removed in 2013). The drop-down contains the commands: Surface, Radar and More Charts.
Other Charts - (Removed in 2013). Drop-Down. Provides access to other chart types. The drop-down contains the commands: Stock, Surface, Doughnut, Bubble, Radar and All Chart Types.


Tours

In Excel 2016 the Power-Map functionality was fully integrated.
In Excel 2013 this functionality was made available by installing the Power Map add-in.

3D Map - (Added in 2013). Button with Drop-Down. The button displays the "Power Maps for Excel" window. The drop-down contans the commands: Launch Power Map and Add Selected Data to PowerMap. Allows you to create data visualisations in your workbooks. You must enable the Data Analysis add-ins to use this feature. This feature uses DirectX 10 ?


Reports

In Excel 2016 this group was removed.
In Excel 2013 this group is only displayed if you have the Power View add-in loaded.


Sparklines

Line - (Added in 2010). Displays the "Create Sparklines" dialog box which lets you insert a line chart within a single cell.
Column - (Added in 2010). Displays the "Create Sparklines" dialog box which lets you insert a column chart within a single cell.
Win/Loss - (Added in 2010). Displays the "Create Sparklines" dialog box which lets you insert a win/loss chart within a single cell.


Filters

Slicer - (Added in 2010). Filter dates in your Tables. Exactly the same command can be found on the Table Tools - Design Tab.
Timeline - (Added in 2013). Filter dates in your tables, pivot tables and pivot charts.


Links

In Excel 2007 this group appears immediately after the Charts group.
This is because the Sparklines and Filter groups were added in Excel 2010.
Link - (Added in 2017). Button with Drop-Down. (Ctrl + K). Displays the "Insert Hyperlink" dialog box. The drop-down contains a list of recent items.
Hyperlink - (Removed in 2017). Renamed to Link in 2017.


Comments

Comment - Insert a note into the active cell.


Text

Text Box - Inserts a textbox that can be positioned anywhere on the page.
Header & Footer - Switches to Page Layout view and automatically puts your cursor in the header box. This will then display the "Header & Footer Tools - Design" contextual tab. To exit just click out of the header or footer.
WordArt - Drop-Down. Gives you a choice of Word Art styles to insert. The drop-down contains a gallery of different styles.
Signature Line - Button with Drop-Down. The button inserts a signature line that specifies the individual who must sign. The drop-down displays the commands: Microsoft Office Signature Line and Add Signature Services.
Object - Displays the "Object" dialog box allowing you to insert embedded objects.


Symbols

Equation - (Added in 2010). Drop-Down. The drop-down contains the commands: Area of Circle, Binomial Theorem, Expansion of a Sum, Fourier Series and Insert New Equation.
Symbol - (Moved in 2010). Displays the "Symbol" dialog box.


Important

None of these can be inserted from the Insert tab despite appearing on the Insert drop-down menu in Excel 2003.
Insert Cells appears on the Home Tab.
Insert Worksheet appears on the Home Tab.
Insert Function appears on the Formulas Tab.
Insert Comment appears on the Review Tab.


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext