Show/Hide Toolbars

Help & Advice

The Ribbon contains most of the features you will use when creating a spreadsheet, The Ribbon is organized into different tabs, each tab contains features relevant to that tab

 

ribbon_home_excel_2013

 

The Home tab contains all the items you will use the most when creating a spreadsheet such as font styles, font sizes, paragraph styles, cell alignment and formatting as well as basic tools such as cut, copy and paste, find/replace and insert/delete cells

 

ribbon_insert_excel_2013

 

The Insert tab contains options to insert charts, tables, pictures, drawings as well as page breaks, headers/footers and other elements such as date/time, signatures etc

 

ribbon_pagelayout_excel_2013

 

The Page Layout tab contains options to alter page size, margins and general layout settings for items on the page

 

ribbon_formulas_excel_2013

 

The Formulas tab has all the options relating to working with and manipulating the data in your spreadsheet using functions and formulas

 

ribbon_data_excel_2013

 

The Data tab has tools to work with data from external sources and to sort and group data

 

ribbon_review_excel_2013

 

The Review tab contains items to proof (spellcheck etc) your document as well as tracking changes and protecting your workbook

 

ribbon_view_excel_2013

 

The View tab contains options for changing the current view, zooming in/out, arranging windows and working with Macros

 

ribbon_powerview_excel_2013

ribbon_powerpivot_excel_2013

 

The Power View and PowerPivot tabs appear when you choose Power View from the Insert tab - and gives you access to tools to define visually attractive summaries of your worksheet data