Microsoft Excel Parts And Their Functions (Excel User Interface)

Table of Contents[Show]
Microsoft Excel Parts And Their Functions (Excel User Interface)

After getting to know Microsoft Excel, now we will get acquainted with the Microsoft Excel user interface. Knowing the functions of these parts of Microsoft Excel is important so that our productivity in using Excel is more optimal.

Since the introduction of Microsoft Office Excel 2007 version, there have been many changes in the appearance of Excel. Meanwhile, in later versions (excel 2010, excel 2013 and the last excel 2016) there were only minor changes.

The following are the main parts of the Microsoft Excel number processing application.

Start Screen in Microsoft Excel

Since the Excel 2013 version, Microsoft has started to introduce the Start screen or initial display as below when you first open the Microsoft Office Excel application.

Microsoft Excel Parts And Their Functions (Excel User Interface)


The start screen display is divided into 2 panels.

On the left panel you will find a list of the Excel files that we just opened earlier. On the left side of the Excel start screen, we will also find a button or Open Other workbooks menu at the bottom of this left panel. We can use this menu to select a saved file that we will open if we want to open a file that is not in the file list above.

In the right panel there is a default template available in Microsoft Excel. If the template we need is not there, we can use the search box at the top to search for excel templates from the database owned by Microsoft excel online.

To open a new file click / select on the first list called Blank Workbook . Apart from choosing a blank workbook template, we can also use a shortcut to open a new blank file. In Microsoft Office 2013, the start screen will open by default when we open Microsoft Excel. If you want to immediately open the Blank workbook, we can deactivate this start screen by opening File - Options - General and in the start up options group, unchecked the Show the start screen when the application starts as you can see in the picture. following.Ctrl + N

How to Disable the Start Screen in Excel

Application Window in Excel

After successfully opening the Blank Workbook, you will get an application display that is more or less like the one below.

Part of Microsoft Excel 2010,2013,2016

Some parts of Excel from the Excel application window are as follows:

1) Quick Access Toolbar: This section contains Buttons or general menu buttons that we often use. We can adjust these buttons as needed.

You can learn the details on the following page: Quick Access Toolbar in Microsoft Excel

2) Ribbon: This section is a collection of command buttons in Microsoft Excel which are grouped into tabs based on their functions from Home, Insert, Page Layout, Formula, Data, Review, and View. And the Developer Tab which is hidden by default.

Each tab is grouped based on a series of functions. For example on the Home tab: Clipboard, Font, Alignment, and so on.

3) Formula Bar: This section shows the active cell address and its contents. The formula bar is also a place where later we will write excel formulas or formulas.

4) Worksheet Area: Also known as Workspace. Contains a collection of cells identified by column (Column) with symbols of letters A, B, C and so on. and row (Row) with numeric symbols 1, 2, 3 and so on. In this cell we arrange the data as needed.

5) Status Bar: This section shows the status information of the Excel program that is running.

Backstage View in Office Excel

Backstage View in Office Excel


This Backstage View will appear when we click the file menu next to the Home tab on the Ribbon. This backstage view was introduced since the Excel 2010 version.

In this backstage view, we will find information related to the excel file that we are opening as well as the menu or option buttons for excel settings.

Excel Ribbon

Excel Ribbon

Tabs Menu: Contains a set of buttons that are grouped according to their function. By default there are Home Tabs, Insert, Page Layout, Formulas, Data, Review and View. Meanwhile, the Developer tab is hidden. To appear we need to make arrangements first.

Group Menu: Within each tab the buttons are further grouped into groups. Each group is separated by a vertical line. On the Page Layout tab above, there are Group Themes, Pade setup, Scale to fit, Sheet Options and Arrange.

Command Buttons: Within the group there are several Command Buttons or command buttons according to their respective functions.

Dialog Box Launcher: In some corners of the Group Menu there is a Dialog Box Launcher to display further settings for each group which by default these settings are not displayed.

Before going, don't forget to Bookmark and share this excel tutorial article with the buttons provided below. Greetings Excel Class.

Leave a Comment