Microsoft Excel FREE Resources Index Page

Excel For Mac 2016 How To Get To The Backstage Area
Excel For Mac 2016 How To Get To The Backstage Area In The World
Excel For Mac 2016 How To Get To The Backstage Area In Minecraft
Excel For Mac 2016 How To Get To The Backstage Area In Animal Crossing
Excel For Mac 2016 How To Get To The Backstage Area In Fortnite
Excel For Mac 2016 How To Get To The Backstage Area In Disney
Excel For Mac 2016 How To Get To The Backstage Area In Photography

Sep 16, 2014 Therefore, the plot area needs to be smaller than the chart area to fit the axis labels, and titles outside the chart. Get Your Question Answered. This article is based on a question from Tony. You can get your Excel or VBA question answered too! Click the link below to submit your question. . Show Ribbon in Excel - Hide Ribbon in Excel 2016 The Ribbon in Excel can be displayed in full, partially or completely hidden. It is important to know where to find the options to manage the Ribbon display settings, not only to maximize the worksheet area on your computer screen, but also to re-display a Ribbon that has disappeared.

Free Online Microsoft Excel Tutorials

* What is the Ribbon in Excel 2016?
* Show Ribbon in Excel - Hide Ribbon in Excel 2016
* How to find Excel Functions on the Ribbon in Excel 2016
* Contextual tabs that disappear
* Quick Access Toolbar Excel 2016 - The shortcut menu or QAT
* Adding buttons to the Quick Access Toolbar Excel 2016

The Ribbon and Quick Access toolbars in Excel are the control centers for functions, options and settings needed to create and edit worksheets.
Both these toolbars work in very specific ways and understanding how they are organized may increase your productivity substantially.

* What is the Ribbon in Excel 2016?

The Ribbon in Microsoft Office applications is the name given to the bar at the top of the Excel 2016 screen which contains functions, options and settings required to create and edit worksheets. The Ribbon is divided into different functional areas using tabs, and under each Ribbon tab, you will find function buttons organized into groups of related command buttons.

Excel For Mac 2016 How To Get To The Backstage Area

Study the screenshot of the Excel Ribbon / Menu area below. Can you identify these areas in your own version of Microsoft Excel 2016?

1. Tabs:Home, Insert, Page Layout, Formulas, Data, Review and View are all default menu tabs on the Ribbon. When clicked, each of these tabs open a different area of the Ribbon with option buttons pertaining to the name of the tab under which they are located.

2. Ribbon area (also known as Commands): This is where the option buttons relating to the selected tab on the Ribbon, is located. Option buttons are organized into named groups divided by a single vertical line.

3. Search the Ribbon: Click and type into this area to find an Excel function.

4. Ribbon display options: Select to show/hide the Ribbon, the Ribbon Tabs and Command area.

5. Hide the Ribbon: Click to collapse (hide) the Ribbon.

Excel For Mac 2016 How To Get To The Backstage Area

Go ahead and experiment in Excel:

What happens when you click each of the tabs at the top of your Excel screen: Home, Insert, Page Layout, Formulas, Data, Review and View?
Can you tell when a Tab is selected? Did the Ribbon area (Commands) change as you clicked on each tab?

Let’s investigate how the Ribbon commands area is organized. Study the screenshot below of two groups usually found under the Home tab. Can you find these on your version of Excel?

The areas identified above, which are numbered and color-coded, are:

1. Groups - these contain individual buttons (commands) that can be clicked to use the option. For most commands you will need to have selected content in your worksheet or have your cursor positioned within a cell in the worksheet.

2. Group names - each group on the Excel Ribbon has a name that pertains to the buttons in the group. In the screenshot above the Font and Alignment groups are outlined in blue.

3. More options - some buttons have further options when you click the small triangle to the right of/or below the button. The further options identified in the screenshot example above will give you different border, text orientation and merge and center options.

4. Dialog Box Launcher - many groups on the Ribbon have a small triangle in its bottom right-hand corner. Click on this icon to launch a dialog box that contains a plethora of options relating to the group.

The screenshot in our example contains only two groups found under the Home tab on the Ribbon. The Ribbon contains over 40 groups which can be accessed by clicking on one of the Ribbon tabs.

* Show Ribbon in Excel - Hide Ribbon in Excel 2016

The Ribbon in Excel can be displayed in full, partially or completely hidden. It is important to know where to find the options to manage the Ribbon display settings, not only to maximize the worksheet area on your computer screen, but also to re-display a Ribbon that has disappeared.

Study the screenshot below. Can you find these Ribbon display options in your version of Excel?

1. To hide the Ribbon: click on the Collapse the Ribbon icon to the right of the Ribbon area.

2. Click on the Ribbon Display Options button to:

Auto-hide Ribbon - this will hide the entire Ribbon area.
Show Tabs - this will show the tabs at the top of the Ribbon only
Show Tabs and Commands - this is the default Ribbon view, which displays the whole Ribbon (Tabs, groups and buttons).

To re-display the Ribbon try one of these options:

1. Hold down the Control key on your keyboard and press the F1 key (Ctrl+F1). This will re-display the Ribbon regardless of which parts are hidden.

2. Right-click one of the Tabs on the Ribbon and select Collapse the Ribbon from the menu that appears.

3. Click on the Ribbon Display Options button and select one of the display options from the menu that appears.

* How to find Excel Functions on the Ribbon in Excel 2016

A common frustration experienced by Microsoft Office users in the past have been the difficulty in locating a function on the menu bar or Ribbon. Excel 2016 comes with a fantastic new feature, the aptly titled Tell me what you want to do search box which allows users to search for any function using descriptive words.

To use this search function on the Ribbon:

Excel For Mac 2016 How To Get To The Backstage Area In The World

1. Click on the words Tell me what you want to dolocated to the right of the last tab on the Ribbon.

Ex