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_2016

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_2016

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

 

 

ribbon_pagelayout_excel_2016

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

 

 

ribbon_formulas_excel_2016

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_2016

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

 

 

ribbon_review_excel_2016

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

 

 

ribbon_view_excel_2016

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