Please enable JavaScript to view this site.

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

 

contextualribbon_drawingtools_format_excel_2016

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_2016

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_2016

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_smartart_design_excel_2016
contextualribbon_smartart_format_excel_2016

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_2016
contextualribbon_charttools_format_excel_2016

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_2016

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

 

 

contextualribbon_equationtools_design_excel_2016

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_2016
contextualribbon_pivottabletools_design_excel_2016

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_2016
contextualribbon_pivotcharttools_design_excel_2016
contextualribbon_pivotcharttools_format_excel_2016

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

 

 

contextualribbon_sparklinetools_design_excel_2016

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

 

 

contextualribbon_slicertools_options_excel_2016

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

 

© 2004 - 2023 PC Assist @ Home

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC