In the following image, you can see the basic parts of an Excel window. ⏷ What Is an Excel Workbook?
⏷ Basic Parts of Excel Window
⏷ Excel Ribbon Structure
⏷ Different Types of Excel Cursors
⏷ Common Excel Dialog Boxes
⏷ Excel Status Bar Options
⏷ Contextual Menus in Excel
⏷ Different Types of Task Panes
When you open a blank Excel workbook, you will find the following Excel window.
Worksheet: After opening an Excel workbook, we get a window of Excel to perform any required operation that is the worksheet.
Cell: The cell is the shortest part of Excel. Usually, a cell is denoted by the combination of row and column headings. Cell A1 means that the cell is located in the first column and first row. Cell numbers are unique.
Active Cell: When we click on any cell, it becomes the active cell. The address of the active cell is shown in the Name Box at the upper left corner of the sheet.
Row: Row is the horizontal collection of cells and is denoted by a number. On the left side of the sheet, you can see the row bar that indicates all rows. Excel has 1,048,576 rows in total.
Column: The column is the vertical collection of cells and is denoted by alphabetic characters. You will have a bar on the upper side of the worksheet consisting of alphabetic characters starting from A, that is the column bar. Each character of this bar indicates individual columns. Excel has 16,384 columns in total.
Title Bar: The Title bar is the horizontal bar that contains the name of the Excel file and is located at the top of the workbook.
Quick Access Toolbar: The Quick Access Toolbar or QAT is a customized toolbar, located at the left-upper side of the workbook. We gather all the frequently used commands here so that there is no need to search for them.
Control Buttons: Control buttons are located at the upper-right side of the workbook and are used for control purposes like minimizing, maximizing, and closing.
Ribbon: The Ribbon is the key interface in Excel that organizes and contains various commands. It is divided into tabs, each housing groups of related commands. It was first introduced in Excel 2007 and is available in all the latest versions including Excel 365.
Formula Bar: Formula bar is located below the ribbon. We can insert, modify, and delete any value or formula in Excel from this bar. We can also see the formula of any cell in this bar.
Name Box: The Name Box is on the left side of the Formula Bar. We can see the address cell or name of a range from this box. We can also go to the desired cell or select the range by inserting the cell reference or name in this box.
Scroll Bar: The scroll bar is used to navigate the Excel worksheet in 4 directions. There are two scroll bars: the horizontal scroll bar for left and right, and the vertical scroll bar for up and down directions.
Sheet Tab: The sheet tab contains the names of all available sheets on the workbook. We can also create new sheets from there. It is also called the leaf bar. It is located at the bottom left corner of a workbook above the Status Bar.
Status Bar: The status bar is a horizontal bar located at the bottom of the workbook. It indicates the current status of the selected cell and other mathematical calculations like sum, average, count, etc.
Zoom Slider: It refers to the zoom adjustment of Excel workbooks that ranges from 10% to 400%. It is located at the bottom-right corner of the Excel workbook.
View Buttons: This button refers to different ways to present the workbook in Excel. There are three modes: Normal, Page Layout, and Page Break Preview.
The Excel ribbon has the following basic components: Tabs, Command Groups, Command Buttons, and Dialog Box Launcher.
Tab: A tab is an entity that organizes a similar group of commands in Excel. Each tab stands for a specific purpose. Like, the Insert tab is used to insert tables, illustrations, charts, maps, sparklines, etc. in the dataset.
Command Groups under Each Tab: Under each tab, there are multiple command groups to do specific tasks. Example: The Font group under the Home tab is dedicated to font size, color, style, and other font-related tasks.
Command Buttons under Each Group: These are different buttons under each command group. Each command button performs a specific task. Example: the Font Color button sets the color of the font.
Dialog Box Launcher: The dialog box launcher is a small arrow symbol located at the bottom-right side of any command group. Some command groups contain more commands than shown in the Ribbon. The dialog launcher (also called an anchor arrow) shows the other commands related to each group in a pop-up window.
When you hover the cursor over a cell or select a cell, the cursor looks like this.
It is a small plus sign when hovering over the right-bottom corner of a cell. Clicking and dragging or double-clicking on the cursor will copy the formula or values inside to subsequent cells.
The I-beam cursor is displayed when entering values into cells directly.
The mouse pointer shows up when hovering over anything that’s not a cell or text box.
It looks like a four-directional arrow sign and appears when placing the cursor at the edge of the selection range. Dragging the cursor to another location will move the selected data.
Place the cursor on the edge of the selection area, then press and hold the Ctrl button. You will see a small plus icon with the mouse pointer, which is Copy Cells cursor. Using this cursor, you can copy, move, and do other activities.
It appears when you hover over the column or row bar and turns the cursor into a down or right arrow. It’s used to select the entire column or row.
When the cursor is placed at the border of two columns or rows, it will turn into a two-directional arrow. It can resize the width or height of a column or row, respectively.
We get this dialog box from the Clipboard group of the Home tab. Our copied data is shown in this dialog box.
Opened from the Font, Number, or Alignment group of the Home tab. Used to customize the data format like category, size, color, style, alignment, add a border, fill color, etc.
Pressing Ctrl + F or H will get this dialog box. Also opened via Find & Select > Find or Replace. From the Find tab, you can search for any data, and from the Replace tab you can replace the existing data with new ones.
Go to Find & Select and choose Custom Sort to get this dialog box. You can sort data in multi-level and multiple categories from this dialog box.
Go to Sort & Filter and select Advanced to open it. You can select both the data and criteria range and apply the advanced filter from this box.
Opened via the Page Layout tab. Click on the dialog box launcher of groups Page Setup, Scale to Fit, or Sheet Options. You can use it to customize page orientation, scaling, paper size, margin, header, footer, print area, page order in printing, etc.
You can open the Insert Function dialog box by clicking on the fx sign next to the Formula Bar. You will get the list of Excel functions based on different categories to insert into the formula bar.
Go to Data and select Data Validation to get this dialog box. It allows you to control the entry of data in a cell.
You will get this dialog box by going to Data and selecting Consolidate. It summarizes information from multiple worksheets into a master worksheet.
Go to Insert and select the PivotChart drop-down, then choose PivotChart & PivotTable to get this dialog box. Select a table or range as source data and another location to place the pivot table and chart in the workbook.
Click on the dialog box launcher of the Charts group of the Insert tab. You can select the desired chart from the recommended options or a list of all charts.
To get this box, click on the Link command in the Insert tab. You can link any file (Image, document, etc.), web page, sheets of the existing workbook, and email address.
In Home, go to Conditional Formatting and select Manage Rules to get this dialog box. You can create, edit, delete, and duplicate conditional formatting rules from this box.
Go to Formulas and select Name Manager. It can be used to create, edit, and delete names for ranges. You can also modify the reference of shown names from here.
The status bar is the horizontal bar at the bottom of the workbook. By default, this bar shows a real-time status of the workbook: Cell Mode, Macro recording, Accessibility, mathematical calculations, View buttons, and Zoom Slider.
Here’s how you can customize it:
You can hide or unhide the status bar easily by using the keyboard shortcut Ctrl + Shift + F1.
The Context Menu appears by right-clicking on any object like a cell, chart, shape, or command. Here is a cell’s context menu.
Options in this context menu are related to the data in a cell like: copy, cut, paste, sort, filter data, insert, delete, format cells, etc.
The features of this menu are related to the Quick Access Toolbar and the ribbon.
We get two types of context menus from the ribbon:
Hover the mouse over any sheet name of the Sheet Tab and get this menu. It consists of options like insert, delete, rename, move, copy sheets, etc.
It’s used to change the fill color, outline color, chart type, data, etc. of a chart.
You can modify texts, points, links, size, and other properties of shape from this menu.
You can modify the font style, color, size, and format of data and show different mathematical calculations and other options related to the pivot table from this menu.
Task Pane is a supporting tool of Excel. Usually, a Task pane is shown in a rectangular box. Each task pane shows different functionality, such as selecting any option, inserting a value, etc.
This task pane checks the accessibility of the workbook and suggests how to make the workbook more accessible after fixing disabilities.
Click on the Accessibility Checker icon on the left side of the Status Bar and the task pane will be located on the right side of the workbook.
This task pane is accessed from the Clipboard group of the Home tab and appears on the left side of the workbook. It lists the copied data, and we can paste or delete it from the Clipboard.
There is also an Options button at the bottom of the taskbar with other features.
Click on the Navigation feature of the View tab to open this task pane. In this pane, you can view all the elements, such as tables, images, charts, PivotTables, and datasets, of each worksheet of the workbook.
We will get this by right-clicking on a chart. This task pane shows all the chart’s properties for customization.
Select a range of data and click on the Analyze Data feature of the Home tab to get this task pane. You can see different insights of the dataset and can ask any question regarding the dataset. Previously, it was called Ideas.
Accessed from the Smart Lookup option of the Review tab. This task pane shows definitions, images, web pages, and related information of the selected data after searching.
This task pane shows the translation of the inserted word or sentence. You can access it by clicking on the Translate option under the Review tab.
This task pane shows the synonyms and antonyms of inserted words in Excel. Click on the Thesaurus option of the Proofing group under the Review tab to access it.
You will be able to see all the details of a cell in this task pane like the workbook name, sheet name, value, formula, etc. of the selected cell. Click on the Watch Window option of the Formulas tab for this pane.
The Data Selector task pane appears when you change the data type of the inserted data from the Data Types group under the Data tab. This task pane shows suggestions based on your data type selection.
