Show/Hide Toolbars

Help & Advice

There are also several contextual tabs that only appear when performing specific tasks, the main ones are summarized below:-

 

contextualribbon_drawingtools_format_excel_2013

 

The Drawing Tools - Format tab appears when you are performing any graphical functions such as inserting drawings or charts and provides various tools to create graphics, change colours, styles and positioning of items

 

contextualribbon_picturetools_format_excel_2013

 

The Picture Tools - Format tab appears when you click on an image in your document and allows you to edit it by way of cropping, colour correction, artistic effects, altering its position and adding borders

 

contextualribbon_tabletools_design_excel_2013

 

The Table Tool - Design tab appears when inserting and working with table elements and provides tools to change and configure the table style and layout

 

contextualribbon_smartarttools_design_excel_2013

contextualribbon_smartarttools_format_excel_2013

 

The SmartArt Tools - Design and Format tabs appear when you are editing a SmartArt graphic you inserted via the Insert ribbon

 

contextualribbon_charttools_design_excel_2013

contextualribbon_charttools_format_excel_2013

 

The Chart Tools - Design and Format tabs appear when you insert a Chart into your document and allow you to further customize it

 

contextualribbon_headerfootertools_design_excel_2013

 

The Header & Footer Tools - Design tab appears when you are inserting or editing the header/footer in your document

 

contextualribbon_inktools_pens_excel_2013

 

The Ink Tools - Pens tab appears when you choose Start Inking on the Review tab and gives access to pen settings, colour and line thickness

 

contextualribbon_equationtools_design_excel_2013

 

The Equation Tools - Design tab appears when working with equations in your document and allows you to insert symbols and change the equation structure

 

contextualribbon_pivottabletools_analyze_excel_2013

contextualribbon_pivottabletools_design_excel_2013

 

The PivotTable Tools - Analyze and Design tabs appear when you are working with a Pivot Table inserted via the Insert tab

 

contextualribbon_pivotcharttools_analyze_excel_2013

contextualribbon_pivotcharttools_design_excel_2013

contextualribbon_pivotcharttools_format_excel_2013

 

The PivotChart Tools - Analyze, Design and Format tabs appear when working with a Pivot Chart inserted via the Insert tab

 

contextualribbon_sparklinetools_design_excel_2013

 

The SparkLine Tools - Design tab appears when you insert Sparklines via the Insert tab

 

contextualribbon_timelinetools_options_excel_2013

 

The TimeLine Tools - Options tab appears when working with Timeline filters inserted via the Insert tab

 

contextualribbon_slicertools_options_excel_2013

 

The Slicer Tools - Options tab appears when working with Slicer filters inserted via the Insert tab