Tamim Ahmed
Tamim Ahmed
25 Dec 2022 (5 months ago)
Araihazar, Narayangonj, Dhaka, Bangladesh
Microsoft Excel Complete Tutorial – Modern Version MS Excel 2021

Listen to this article

Microsoft Excel is a widely popular program for doing calculations on a computer. It is a spreadsheet program. The company that developed the Windows operating system that we use i.e. Microsoft Corporation is the company that originally developed it. Through which very difficult and large types of data or information can be easily calculated in moments. And this program is basically my topic today.

Introduction to Microsoft Excel:

We first said that Excel is a spreadsheet program that is arranged in a cell (Cell) or cell grid, row (Row) or row and column (Column). These cells are used to enter, store and manipulate data. The Excel spreadsheet program is a part of the Microsoft Office package. The current version of Microsoft Office is 2021. We all know that the other programs inside the Microsoft Office package are Word, PowerPoint, Access, Outlook, OneNote, MS Publisher, MS Project and MS VCO. And one of them is the Excel program of our today’s topic.

With Excel spreadsheets, you can do simple to complex tasks in accounting. Although Excel is the leading program in the world, most of its users have very limited knowledge of the various functions of Excel. A survey found that 70% of Excel users use or know only 5% of Excel’s functions. In other words, Excel can be used for almost every organizational task. Some of the uses or functions of Excel are highlighted below.

  • Create, edit, summarize, analyze, summarize and format data.
  • Engineering and Construction.
  • Science
  • Complex mathematical and statistical calculations.
  • Complex data analysis.
  • Budget.
  • Accounting and Payroll.
  • Investments and shares.
  • Sales and Marketing.
  • Production planning, material management and inventory.
  • Creating graphs and charts using complex data.
  • Automating Tasks Using Macros

A variety of complex accounting tasks such as those mentioned above can be easily done through Excel.

Launch the Microsoft Excel program:

There are various methods to launch any program installed in the computer using which we can launch any program. Similarly, in the case of Excel program, we can launch the Microsoft Excel program by adopting different methods. Below are some methods.

Using the desktop shortcut:

If there is a shortcut icon for the Excel program on your computer desktop, find it and open the Excel program by double-clicking on it. And if you can’t find it, i.e. the icon of the Excel program is not on your desktop, then see below how to create a shortcut of the Excel program on the desktop.

Locate the Excel executable file inside its installation folder on your computer. The Excel executable file can be found within the Microsoft Office installation folder. You can find the Excel executable file in the following folders location.

Windows 64-bit:

If your windows is 64 bit then the location address will be like this – C:\Program Files\Microsoft Office\Office16\

Windows 32-bit:

If your Windows is 64 bit then the location address will be like this – C:\Program Files (x86)\Microsoft Office\Office16\

After finding the Excel executable file, click the right mouse button on the Excel executable file (EXCEL.EXE) and click the Send to > Desktop button as shown in the above screenshot. (create shortcut)

After creating the desktop shortcut of the Excel executable file, it will be created on your computer’s desktop just like the screenshot above. Now you can open or launch the Excel program on your computer anytime by clicking on it.

Using the Start Menu:

Basically the start menu is used to open or launch any program installed on the computer. You can open or launch any program in two ways using the Start menu.

According to the first method, click on the Start menu and go to All Programs and open or launch the program by clicking on the program called Excel from the E serial according to the serials of A, B, C, D.

According to the second method, click on the start menu and type Excel in the search box. And you will see that the Excel program has arrived and click on it to open or launch the Excel program.

Close the Microsoft Excel program:

All computer programs have a separate button to close the program, which we call the Close button marked in red. You can close the Excel program by using that button in the Excel program as in other programs.

To close the Excel program, click on the red marked Close button on the upper right side as in the above screenshot.

Then see a window or dialog box or popup like above screenshot. Here it tells you whether you want to save or save this Excel sheet or file to the computer. (The above box will appear only when the file is not saved on the computer.) If you want to save, click on the Save button and if you don’t want to, click on the Don’t Save button.

Another method you can use to close the Excel program is to use a keyboard shortcut command. For this you need to press Alt+F4 button together from the keyboard. Then you will see that your program is closed. (Note that any computer program can be closed with the shortcut command.

(Note that the screenshots mentioned in the post are taken from operating system version Windows 11 and Excel version 2021. So if your operating system version and Excel version are different, some windows or dialog boxes or popups will appear differently.)

Microsoft Excel Start Screen:

The first screen that appears after launching the Microsoft Excel program is called the Start Screen or Excel Screen. The screen that will appear after starting the Excel program is exactly like the above screen. Here are a few different things that we will learn about below.

Window control or Close, Maximize and Minimize buttons:

Every computer program has window controls or Close, Maximize and Minimize buttons. In view of that, the Excel program also has these three buttons. The Close button is used to close the Excel program completely. The Excel program can be minimized or enlarged from full screen using the Maximize or Restore buttons. Also other programs can be used within one screen. The Minimize button can keep the Excel program running on the taskbar without closing it.

Upcoming Features and Accounts:

The icon marked (1) in the screenshot is called Upcoming Features. Through which you can know whether any new features or features have come to the Excel program. But it will require internet connection. If you have a Microsoft email account in the (2) part marked in the screenshot, you can add it here. Through which you can enjoy some benefits.

Search, title bar and quick access tool bar:

The section marked (1) in the screenshot contains the search bar. Through this, if you do not know anything about the Excel program, you can find out by searching. For example, you don’t know where to go or how to open an Excel file. In that case, go to this search bar and search by writing Open and see that the Open function is available. Marked in the screenshot (2) is the part title bar. This will basically show your file name. (3) The marked part is called Quick Access Toolbar. Some tasks can be done quickly through various buttons on it. Like taking new file, saving file, opening saved file etc.

Tabs, Ribbons and Sections:

The Home, Insert, Page Layout, Formula, Data, Review, View, etc. sections marked in the screenshot (1) are called tabs. And each tab has (2) ribbons. where there are different types of functions. Again the ribbonbar has (3) sections. That is, the ribbon is divided into different names. Like undo, clipboard, font etc.

Cell Name and Active Cell, Formula Bar and Cell Contents:

Cell names, formula bars, and cell contents are at the top of the worksheet. The first part marked (1) is the cell name box, the second part marked (2) is the formula bar and the third part marked (3) is the content cell. The cell name box basically tells you which cell you are currently in which is called the active cell (4). You can enter or view a formula or content between the formula bar and the content cell.

Header or column and row

The part marked in the screenshot is called (1) column. Which covers up to 16384 English alphabets from A to XFD. The part (2) marked in the screenshot is called Row. English numbers range from 1 to 1048576 digits. And these columns containing English alphabets and rows containing English numbers are collectively referred to as headers.

Scrollbar:

The part marked (1) in the screenshot is called the vertical scrollbar. Through which you can move up and down the excel sheet. And (2) part is called horizontal scrollbar. which allows you to move left and right in an excel sheet.

Sheet or Worksheet:

The part marked in the screenshot is (1) sheet which is like a separate page. (2) Marked part is for taking multiple sheets. (3) Marked section is a navigation tool to move from one sheet to another if there are multiple sheets.

Status bar:

The part marked in the screenshot is called the status bar. Many things can be done through this status bar including page mood, and zoom. (1) Page Mood allows you to change the mood of an Excel worksheet. (2) Zoom option allows you to zoom in and out of the page.

Excel Backstage View or Excel Backstage View:

The Excel backstage view is an area of ​​the Excel program from which various features of the Excel program can be used or performed. To launch Excel Backstage, click on the File button from the tab position located above the Excel program.

The screen that appears after clicking the File button is called Excel Backstage. Its form is changing with every update. The current 2021 version has two panels left and right. There are about 14 menus or buttons or options on the left side. Below we will discuss each of them step by step.

Home:

The home option that comes up by default when backstage is clicked on a file. The home menu will show ready-made Excel formats or templates that can be easily manipulated. Also, recent Excel files or sheets saved on the computer can be seen here. And any saved file can be pinned and viewed.

New:

We know new in Bengali language. New button is used to open another workbook or window or page in Excel program. Clicking on the New button will divide the lower and upper part into two parts. At the top you will see a workbook called Blank Workbook, click on it to get a blank workbook. And in the lower part there will be many category based readymade templates. Clicking on them will also take you to workbooks on various topics. Where only data or information has to be changed.

Open:

By open we mean something open. Similarly, with this open button in the Excel program, any Excel file previously saved on the computer can be opened and the Excel file can be reworked or printed. After clicking the open button, two panels or sites appear. In the left panel Recent, OneDrive, This PC, Add a Place and Browse can be seen. And the right panel shows the preview of the buttons on the left. For example, clicking on the Recent button displays the most recent Excel files saved on the computer in the right panel. One Drive is Microsoft’s online cloud storage service. If the Excel file is saved in the online storage, then the Excel file can be opened from there. This PC and Browse are the location of the computer’s memory through which the file can be opened by going to the location where the Excel file is saved in the computer’s memory. And add a place is to pin or save to this open section for quick access to a location.

Info

The Info menu in Excel Backstage View contains various information about the Excel file. The Info menu contains several alternative methods or options to protect the Excel file from being modified by others To protect a workbook with a password, click Protect Workbook. There are also many other options which we will discuss in detail one by one later.

Save and Save as menu:

The Save and Save as menus are used to save an Excel file to the online cloud or to the computer’s hard disk. The Save button is used to save the changes made to the Excel file. And using the Save As button, the Excel file can be saved in different locations or in the same location with a different name.

Print:

The Excel file can be printed or pressed using the Print button in the Excel backstage view. Also from here page shape etc can be arranged before printing. Such as margins, scaling, orientation, paper size, number of copies, including selecting the printer to print from can be configured. How the print will appear on the paper after the file is printed can be seen through the preview on the right side.

Share:

The Excel file can be shared with others via the online storage OneDrive or any email through the Share button.

Export:

The Excel file can be converted to a PDF or XPS format file and saved on any computer using the Export button in the Excel backstage view. That is, the Excel file type for the workbook can also be changed using this button.

Publish:

The Excel file can be published to Microsoft Power BI via the Publish button in the Excel backstage view. You need to sign-in to do this.

Close:

The Close button in the Excel Backstage view can be used to close the current worksheet or either without closing the entire Excel program. So note that this will only close the worksheet. The Excel program will not close and the program will continue to run.

Account:

Account information can be managed through the Accounts button in the Excel Backstage view. Here you can configure updates and change the Excel program theme, etc.

Feedback:

On clicking the More button there are two buttons called Feedback and Options. The Feedback button in the Excel Backstage view is used to send feedback about the Excel program to the Microsoft Excel development team.

Options:

Features and options related to the Excel program can be configured using the Options button in the Excel Backstage view. When the Options button is clicked, a separate window opens, unlike other menu items in Excel Backstage View. The title of the new window is Excel Options. Various functions can be customized in the Excel Options window. In short, the settings of the Excel program can be changed.

Note: Among the buttons or options mentioned in Excel Backstage, New, Open, Save, Save As and Print buttons or options will be especially useful to us. The rest will usually not be of use to us.

Difference between Excel Workbook:

Basically, an Excel workbook and an Excel file mean the same thing. An Excel file or Excel workbook consists of one or more Excel worksheets. An Excel user usually works inside an Excel worksheet. A worksheet contains cells or cells that contain a grid. Where data, currency data, numbers and formulas etc. are stored.

You can create and edit data within the worksheet. An Excel workbook can contain or store one or more Excel worksheets together. Whenever you pick up a new workbook it has or will have a single worksheet. The default name of a new workbook is Book1 and the default name of the first Excel worksheet is Sheet1. You can rename them later if you want.

An Excel workbook must contain at least one worksheet. That is, you can work with more than one worksheet in a workbook and delete them if you want, but you cannot delete all worksheets. You should keep at least one. And if you want to delete the last worksheet, you will see a dialog box with a warning message.

In previous versions or versions of the Excel program, i.e. versions prior to 2013, Excel workbooks opened in a single Excel window called MDI or Multiple Document Interface.

Starting with the Excel program 2013 version, each Excel workbook opens in its own separate window called SDI or Single Document Interface. The single document interface allows each Excel workbook to open in its own window. Each Excel workbook is shown separately on the Windows taskbar.

Since the Excel program 2007 version, the standard file extension of Excel files is .xlsx. In versions of the Excel program prior to 2007, the standard file extension for Excel files was .xls.

Excel options or settings:

There is a button in the Microsoft Excel program called Option which in simple words should be compared to Settings option. Any app has this function through which various functions of the app can be customized. This option allows you to change the default settings or functions of the Excel program. We will explain this option in detail below.

Enable Excel Option or options or settings:

To open the options or settings of the Microsoft Excel program, click on the File button located at the far left of the ribbon and turn on Backstage. Then click on the More button from the left side panel of Backstage and click on the Options button.

A dialog box or window will open after clicking on the option button. There are a total of 12 panels in the Excel Options dialog box or window. Each panel has a variety of settings associated with it. Below is a discussion about the panels.

General:

At the beginning of the Excel Options or Settings dialog box or window is a panel called General. That panel contains commonly used settings. Like user interface options, new workbook options (like font, font size, number of sheets) etc.

Formulas:

The second panel in the Excel Options or Settings dialog box or window is called Formulas. It contains formulas used in Excel. Such as calculation options, working with formulas, error checking and error checking rules etc.

Data:

The third panel in the Excel Options or Settings dialog box or window is called Data. Here are mainly settings related to data import and data analysis.

Proofing:

The fourth panel in the Excel Options or Settings dialog box or window is called Proofing. Through which there are options related to correction of a word or sentence and spelling check etc. within the Excel program.

Save:

The fifth panel in the Excel Options or Settings dialog box or window is called Save. It contains several settings on how Excel workbook files will be saved. It has options like default workbook file format, automatic recovery etc.

Language:

The sixth panel in the Excel Options or Settings dialog box or window is called Language. Through this option there are options to edit language, tooltip language, program language, help language etc.

Accessibility:

The seventh panel in the Excel Options or Settings dialog box or window is called Accessibility. This includes options to make Excel more accessible to differently abled people. There is also feedback, application display options and more.

Advanced:

The eighth panel in the Excel Options or Settings dialog box or window is called Advanced. This is an option that Microsoft Excel considers more advanced. To use this option, the user must have a high level of knowledge on Excel topics. The Advanced panel is again divided into 14 sections based on different options.

Customize Ribbon:

The ninth panel in the Excel Options or Settings dialog box or window is called the Customize Ribbon. Which is basically used to change or customize the ribbon functions in each tab.

Quick Access Toolbar:

The tenth panel in the Excel Options or Settings dialog box or window is called the Quick Access Toolbar. Through which there are options to change or customize or turn on and off the Quick Access Toolbar above the row of tabs in the Excel program.

Add-ins:

The thirteenth panel in the Excel Options or Settings dialog box or window is called Add-ins. which basically lists the add-ins installed in the Excel program. Excel add-ins are used to provide additional functionality for working within Excel files.

Trust Center:

The twelfth panel in the Excel Options or Settings dialog box or window is called the Trust Center. It is connected to the Microsoft Trust Center. This is basically an option through which you can customize the security and privacy settings related to Microsoft Excel.

Excel program tab:

Tabs contain several groups or sections of commands arranged based on the functionality of the commands. For example, the Formulas tab contains commands related to Excel functions and formulas. After installing the Excel program on the computer, if no customization is done in the Excel program, then the tab list of the Excel program may be less or more according to the version, for example, the number of tabs in the latest version 2021 is 09 in total. The tabs will be labeled as File, Home, Insert, Page Layout, Formulas, Data, Review, View, Help.

File:

The File tab of the Excel program ribbon is used to open the Excel backstage view. Which we have already discussed. Excel Backstage View has many options for working with Excel file customizations. The Excel backstage view is where data in files is edited and managed.

Home:

The Home tab contains several common command functions. There are various functions such as copy, paste, font, paragraph, find and replace.

Insert:

The Insert tab contains functions that allow you to insert tables, photos, 3D icons, icons, charts, etc. into your Excel worksheet.

Page Layout:

The Page Layout tab is primarily used to set up the data in an Excel sheet on a page of a specific size. In short, you can set up the page through the functions mentioned in this tab.

Formulas:

The Formulas tab basically contains Excel formulas for performing various types of calculations. By using which you can easily generate different types of reports.

Data:

The Data tab mainly contains options for filtering, sorting and manipulating data. It also has the function of importing file data from other programs.

Review:

The Review tab basically has the functions of spell checking, thesaurus or supporting words, sharing, protecting and tracking of words in the Excel worksheet. Using which you can easily check the spelling of English words, its supporting words can be extracted. You can also share the sheet with others if you want. You can protect it with a password. Can check if someone has changed any data.

View:

The View tab basically contains commands or functions to display or view the Excel worksheet in different ways. Like changing page views, freezing panes, arranging multiple windows, etc.

Help:

The Help tab provides various types of help mainly related to the Excel program. Here are several ways to get help with Excel programs.

These were basically the default tabs of the Excel program. There is also another important tab in the Excel program called Developer which is not originally in the tablist. If you want to take it as a tablist, you have to add it with the help of Customize ribbon of Excel program Option or Settings option.

Excel Ribbon:

The Ribbon is a strip of buttons and icons across the top of the Excel program. The buttons and icons on the Excel program’s ribbon are divided into tabs based on their functional categories.

Main components or topics of Excel Ribbon:

The four main components of the Excel ribbon are tabs, groups or sections, buttons, and dialog box launchers. We have already discussed about tabs above. Now the rest of the main components are highlighted below.

Group or group Section:

We know that each tab has a separate ribbon and within this ribbon there are again different groups or sections based on the tab. A group or section consists of multiple functions or options and these groups are also named separately. For example, Clipboard consists of several functions called Cut, Copy, Paste and Format Painter in groups or sections.

Button:

Within each group or section there are again buttons. which opens a menu or gallery. For example, clicking on the Conditional Formatting button opens the menu.

Dialog Box Launcher:

The dialog box launcher is basically a button. which is below the right side of each group or section. Clicking it will open the full set of main dialog boxes for that group or section’s functions. For example, if you want to open the entire dialog box set for an Alignment Group or Section, click the button below it.

And see the whole set of them displayed on the screen of your Excel program. And that’s basically how you can bring the entire set of functions of all groups or sections to the screen.

Different types of buttons on the Excel ribbon:

Each tab in the Excel program has a separate ribbon. And these ribbons contain different types of buttons. which appear or act one by one. And in view of this, these buttons can be divided into different categories. Below we will discuss the types or categories of buttons.

Command Button:

One-click buttons are called command buttons. is a common button type or category in the Excel ribbon. For example, if the font size needs to be increased, then to increase the font size, go to the font section or group of the home tab and click on the Increase Font Size button to increase the font size. And for this every time it is clicked, the font size will increase. Such buttons are called command buttons.

Toggle button:

Toggle buttons are another type of Excel ribbon button. There are two types of toggle buttons in the Excel ribbon. Toggle Buttons are designed in such a way that when a toggle button is clicked, its color changes to indicate that the button’s state has changed. such as the bold button. By which a text is changed from light to dark. You will see that this button will look like this when it is inactive. It will look different when activated again. I wrote TutorialBD71 in a cell. I will make it bold. For this I have to click the bold button. But I haven’t clicked yet. So the button now looks the same.

TutorialBD71 See how the button looks when I bold or bold the text by clicking on the Bold button. That is, the shape of the button has changed. And such buttons are basically called toggle buttons.

Split Button:

Another type of button is the Split button with a drop down menu on the Excel ribbon. At the end of the split button is a small downward pointing arrow. Excel Ribbon Split Buttons have a button part and a menu part. When the button part is clicked it acts like a normal or command button. Clicking on the menu section displays the related drop down list of buttons. such as the underline button. If you need to underline a text. Then click on underline button from font section of home tab to give it. I want to draw a mark under the text PathanTechBD, for this I selected the cell of the text and clicked on the underline button. Note that the first of the two parts of the button acts like a command button.

And if you click on the button marked with an arrow pointing down another part, see how many more forms have come. That is, if you want to give a double mark or other forms instead of a single mark below the PathanTechBD text, then you have to click on the button of this arrow marked part. And such buttons are basically called split buttons.

Drop down menu button:

The Excel Ribbon drop down menu button is also a type of button. Drop down menu buttons have a small downward pointing arrow at the end. Clicking the Drop Down Menu button launches a menu drop down. Drop down menu buttons do not command or function like direct command buttons. Only displays the drop down menu. Like Conditional Formatting it is a drop down menu button.

Clicking on it will display a menubar. Which include more different types of buttons or functions. And such buttons are basically called drop down buttons.

Rich Menu Button:

A rich menu on the Excel ribbon is a type of drop down button. which contains more information about the menu item. When you click on these types of drop down buttons, the menu bar that comes up has a detailed description of what the button does under each button. For example, when you click on the Freeze Panes button in the View tab, the buttons you see are called rich menu buttons.

Among the different types of buttons in the Excel ribbon are drop-down gallery-type buttons. A drop down gallery has more options than a simple drop down menu. Items inside a drop down gallery can visually display the effect of menu items inside a drop down gallery. For example, there is a button called Cell Styles in the Styles group or section of the Home tab. Clicking on which you can see different types of cells. Interestingly, without activating the functions of such buttons, simply placing the mouse cursor over them will change the appearance of a cell. And such buttons are called drop down gallery buttons.

Checkbox button:

Another type of button you’ll find on the Excel ribbon is called a checkbox button. These are buttons that have an empty box next to them with a tickmark to enable or disable the button. For example, in the Show section or group of the View tab, Formula Bar, Headings, Ruler, Gridlines, if you check the box next to these buttons, it will be enabled and if you remove the checkmark, it will be disabled. And such buttons are called checkbox buttons.

Collapse Excel Ribbon:

Many times while working in Microsoft Excel program we accidentally lose the ribbon bar displayed on each tab due to some clicks. Due to this, many people are again worried that what happened to the Excel program, how to work now, etc. There is no reason to worry if you are facing such a problem. Because the ribbon is hidden. It can be unhide again. Many times we need full screen while working in our Excel program, if we hide the ribbon, our screen is very large and it is convenient for us to work. And that’s basically why this hide feature of the ribbonbar. So we will discuss below how to use this feature.

Functions of the Collapse Excel Ribbon:

  • Several functions of the Excel Ribbon can be observed when the Collapse or Hide feature is used. which are,
  • When the Excel ribbon is collapsed, the ribbon and the various sections or groups within the ribbon are hidden or hidden. Only tab names are visible.
  • When the Excel ribbon is collapsed, since only the tab names are visible, if you want to work with the functions of a tab’s ribbon and a section or group on the ribbon, click on the desired tab and see its ribbon and section or group displayed on the screen.
  • To reactivate the Excel ribbon when it is collapsed, double-clicking on any tab will reactivate the ribbon.

Usually the ribbon bar of Excel program is displayed in the screen like above screenshot.

When it is collapsed or hidden it is displayed exactly like the above screenshot.

Use ShotCart to enable or disable ribbonbar collapse:

If you want to collapse or hide or hide the ribbon bar of the Excel program using the keyboard shortcut command or you want to enable the hidden or hidden ribbon bar, then you can easily do it using the keyboard shortcut. For this you need to press Ctrl+F1 button from the keyboard. And see if you want to collapse the ribbon, it will act as a hide. And if you want to enable the hidden ribbon then it will be displayed.

Usage of Collapse Ribbon Button:

You can also collapse or hide the ribbon if you want through the Collapse Ribbon button on the Excel ribbon. For this, you have to click on any tab and click on the icon marked at the very end of the ribbon bar of that tab i.e. on the right side and click on Show tabs only button. See if the ribbon in the Excel program is collapsed or hidden.

If you want to re-enable or hide the ribbon bar as before, in the same way click on a tab and click on the button at the far right of the ribbon bar and click on the Always Show Ribbon button. Then you will see that the Excel ribbon is displayed again as before or is automatically activated.

Use of mouse double click:

If you want to collapse or hide or hide the ribbon of the Excel program for some reason, double click on the name of any tab with the left mouse button. And see if the ribbon is collapsed or hidden.

Similarly, if you want to enable the hidden ribbon bar, double click on any tab name in the same way. And see your hidden ribbon reappear.

Using the ribbon display option button:

You can also collapse or hide the ribbon in Excel using the Ribbon Display option button. This button is located next to the Control Window (Close, Maximize, and Minimize) buttons in the Excel program’s title bar. This is mainly found in the 2019 version of Excel programs. You will not get the latest i.e. 2021 version. The button looks exactly like the screenshot above.

After clicking on the button will appear as above screenshot. Here you can auto-hide the Excel ribbon through the Auto Hide Ribbon button. Show Tabs will show only the tabs and not the ribbon. All tabs and ribbons can be seen through the show tab end command.

By clicking the right mouse button on the Excel ribbon:

If for some reason you want to collapse or hide or hide the ribbon bar of the Excel program, then if you place the mouse cursor anywhere on the ribbon bar of any tab and click the right button, it will appear just like the above screenshot. Here you can hide the ribbon by clicking the Collapse the Ribbon button.

Again if you want to enable the hidden ribbon bar as before then you can do it using this same method. For this, if you place the mouse cursor on the name of any tab and click the right button, it will appear exactly like the above screenshot. Here, see the Collapse the Ribbon button with a tick mark, that is, it is active or automatic. Click on it and see that the Excel program’s ribbon is automatically activated again.

Excel formula bar:

The Excel formula bar is located at the top of the Excel worksheet window. You will notice or see that there are three sections in the Excel formula bar. These three parts again have different subjects. Such as cell name boxes, formula bar buttons, and cell contents. Which has been roughly discussed in an earlier episode.

Cell Name Box:

The leftmost part of the Excel formula bar is called the cell name box. The cell name box displays the address of the active cell or cell. Through which we can easily understand how many cells we are in now.

Formula bar button:

The middle part of the formula bar is called the formula button. Here again there are three different types of buttons. One is cancel or close (X), one is enter or tick and another is insert function (fx) button. The Cancel and Tick buttons are only active when you edit a cell. Clicking the Cancel button will cancel your entry in the cell. Clicking on the tick mark will make the data entered in the cell active or entered. Third button clicking on insert function will open its dialog box from where you can see the list of formulas and select a formula as per your need or desire.

Cell Contents:

Excel displays the contents of the active cell from the right side of the formula bar. This is very useful if the content of the active cell is very long or long. Because Excel cells are small, it is difficult to see normally if the data entered in them is too large. Then the cell content of this formula bar makes this matter very easy.

Excel formula bar hide or hide and unhide or show:

Sometimes your Excel worksheet needs more space than the allotted screen space. If you want to hide the formula bar then your worksheet screen will be bigger than before and it will be convenient for you to work. Also many times you will notice that for some reason your Excel program is not showing the formula bar but you want to activate it. So if you ever need or face a problem like this then we will see below how to do it.

To hide or unhide the formula bar from the ribbon bar:

If for some reason you want to hide or hide the active formula bar in your Excel program or re-enable or enable your hidden or inactive formula bar then you can do it by following this procedure. For this you need to click on the tab named View from the tab of the Excel program. Then, if you want to disable or hide the formula bar from the group or section or block called Show from the ribbon, remove the check mark next to the Formula Bar text.
And if it is already disabled, you want to enable it, then in the same way, go to the View tab and check the box next to the Formula Bar from the Show section. And thus by following this method you can easily hide or unhide the formula bar.

Hide or unhide through Excel options:

We have seen above a method to hide or unhide Excel formula bar. This time we will see another method by following which you can hide or unhide Excel formula bar. For this you need to take the help of Excel option button or function of Excel program. Which I have already discussed in a mount. To open the Excel option, click on the File tab from the tab panel, click on the More button at the bottom of the left side panel, then click on the Options button.

Then click on the Advanced option from the left panel and scroll down or scroll to the bottom and uncheck the Show Formula bar box from the Display section to disable the formula bar. Or tick next to the inactive formula bar to activate it. And thus you can easily hide and unhide the formula bar in your Excel program.

Then bro, stay well and stay healthy. And stay with Basics Press to gain knowledge on any unknown topic. And if you like the post, like it. And if you have any comments about this, go to the comment section and comment.
Thanks everyone

479 Views
1 Comment
Forward Messenger
13
Computer Basics of C Programing
-
- -
1 comment to “Microsoft Excel Complete Tutorial – Modern Version MS Excel 2021”

  1. dollarbuyseller12 (5 months ago)

    Thank you very much for uploading class useful and quality content. Good luck material for you with likes and full races
    dollar Buy Sell bd