![\"ribbon](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/ribbon.png\")
<\/a><\/p>\nExcel Ribbon components<\/h3>\n\n- Ribbon start button –<\/strong> It is used to access commands such as creating new documents, saving existing work, printing, etc.<\/li>\n
- Ribbon \u2013<\/strong> The tabs in the ribbon groups the similar commands together.<\/li>\n
- Ribbon bar \u2013<\/strong> The bars in the ribbon are used to group similar commands together. As an example, the font ribbon bar is used to change the font of the data.<\/li>\n<\/ul>\n
There are four components in excel ribbon and they are tabs, groups, dialog launchers and command buttons.<\/p>\n
![\"ribbon](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/ribbon-tab-ss.png\")
<\/a><\/p>\nRibbon Tab :<\/h4>\n
It contains multiple commands which are logically split into groups.<\/p>\n
Ribbon Group:<\/h4>\n
It is a group of commands which are closely related and they are performed as a part of larger tasks.<\/p>\n
Dialog Launcher :<\/h4>\n
It is a small arrow in the right corner of a group which brings up more related commands. It appears in the group’s right corner as a small icon.<\/p>\n
Command Button:<\/h4>\n
It is the button a user clicks to perform a particular action.<\/p>\n
Ribbon Tabs in Excel<\/h3>\n
There are few tabs available in the ribbons such as File, Home, Insert, Draw, Page layout, Formulas, Data, etc.<\/p>\n
File:<\/h4>\n
It navigates the user to the backstage view which contains the information about the file and the excel options . It was introduced in the excel 2010 version as a replacement to the office button in excel 2007 and in earlier versions.<\/p>\n
Home:<\/h4>\n
This tab contains the most frequently used commands in it.<\/p>\n
Insert:<\/h4>\n
This tab adds different objects and charts in the spreadsheet such as Images, PivotTables, Charts, Symbols, Headers, etc.<\/p>\n
Draw:<\/h4>\n
This tab appears based on the device the user uses. This lets the user draw with the digital pen, mouse. This tab is available from the version Excel 2013 and so on. But this tab is not visible like the developer tab by default.<\/p>\n
Page Layout:<\/h4>\n
This tab provides the tool to the users to manage the worksheet appearance. This tab contains tools such as gridlines, page margins, object aligning, print area, etc.<\/p>\n
Formulas:<\/h4>\n
This tab contains the tools for inserting the functions or formulas in the cell.<\/p>\n
Data:<\/h4>\n
This tab provides the commands for managing the data even while connecting to the external data.<\/p>\n
Review:<\/h4>\n
This tab provides the tools such as check spelling, add commands, protects worksheets and workbooks ,etc.<\/p>\n
View:<\/h4>\n
This tab provides the commands for switching between the worksheet views and arranging the multiple windows etc.<\/p>\n
Help:<\/h4>\n
This tab is available in the excel 2019 and office 365 versions. The help tab provides quick access to the help task pane and allows the user to contact Microsoft support.<\/p>\n
Developer:<\/h4>\n
This tab provides access to the advanced features in excel such as macros, form controls and XML commands. This tab is not visible until the user enables it.<\/p>\n
Contextual Ribbon Tabs:<\/h3>\n
The excel ribbon also has context-sensitive tabs which are also known as tool tabs. This shows up only when the users select a certain item such as tables, charts, shapes, etc.<\/p>\n
For example, if the user selects a chart, then the design and format tab appears under the chart tools.<\/p>\n
![\"design](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/design-tab.png\")
<\/a><\/p>\nHow to hide the Ribbon in Excel?<\/h3>\nMinimizing the ribbon<\/h4>\n
The user can also minimize the ribbon by clicking on the symbol near the minimize symbol and then choose the auto-hide ribbon option.<\/p>\n
![\"Auto](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Auto-Hide-ribbon.png\")
<\/a><\/p>\nAuto-hide Ribbon:<\/h4>\n
Auto-hide shows the workbook in full-screen mode and once this option is chosen, it completely hides the Ribbon. To show the Ribbon again, click on the Expand Ribbon command at the top of the screen( three dots).<\/p>\n
![\"auto](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/auto-hideribbon.png\")
<\/a><\/p>\nShow Tabs:<\/strong> When you click on this option, it hides all command groups when not in use, but the tab will remain clear. Simply click on the tab to maximize the ribbon.<\/p>\nShow Tabs and Commands:<\/strong> When you click on this option, it will maximize the Ribbon. All of the tabs and commands will be clear when this option is chosen.<\/p>\nCollapse the Ribbon in Excel<\/h3>\n
The user can collapse the ribbon to increase the size of the worksheet on the screen. When the user clicks on the collapse option, it hides the tabs and commands. To collapse the ribbon, right click anywhere on the ribbon and then select Collapse the Ribbon option.<\/p>\n
![\"Collapse](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/collapse.png\")
<\/a><\/p>\nNote: When the user chooses the collapse option, the result appears as follows<\/p>\n
![\"after](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/after-collapse.png\")
<\/a><\/p>\nExpand the Excel ribbon<\/h3>\n
If the user wants to make the ribbon be visible back again in the excel, then click on that small icon at the right side of the sheet and select show tabs and commands option.<\/p>\n
![\"Expand](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/expand.png\")
<\/a><\/p>\nNote: When the user chooses the Show tabs and commands option, the result appears as follows:![\"expand](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/expand-res.png\")
<\/a><\/p>\nHow to customize Excel ribbon?<\/h3>\n
If the user wishes to personalize the ribbon for their needs then they can also do that now. The entry point to most customizations is the Customize Ribbon window under the Excel Options. The shortest path to customize the ribbon is to right-click on the ribbon and select Customize the Ribbon from the menu.<\/p>\n
Customizing the Ribbon in Excel:<\/h4>\n
You can also customize the ribbon and to do that, follow the steps:
\nStep – 1: Click on the File tab
\nStep – 2: Choose options
\nStep- 3: Click on the customize the ribbon option from the left side of the panel.
\nStep – 4: Customize the ribbon by adding the required commands.
\nStep – 5: Once done, click on the ok button.<\/p>\n
![\"customise](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/customise-the-ribbon.png\")
<\/a><\/p>\nAdding custom tabs on the ribbon:<\/h4>\n
You can also customize the tabs on the ribbon. To do so, follow the steps:
\nStep \u2013 1: Click on the file tab and choose options.
\nStep \u2013 2: Select customize the ribbon option from the left side of the panel.
\nStep \u2013 3: Click on the new tab button and the new tab appears in the list.
\nStep \u2013 4: Right click on it and rename the tab.
\nStep \u2013 5: Select the New Group (Custom) under the new tab.
\nStep \u2013 6: Add commands to the ribbon bar.
\nStep \u2013 7: Click on the ok button.<\/p>\n
![\"customise](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/customise-tab-on-ribbon.png\")
<\/a><\/p>\nHow to show the Developer tab in Excel?<\/h3>\n
The developer tab is an additional tab to the excel ribbon and this tab allows the user to access the advanced features such as Form controls, VBA Macros etc. The one disadvantage is that the Developer tab is hidden by default. But it’s very easy to enable it.<\/p>\n
Developer Options<\/strong><\/p>\nStep 1: <\/strong>To get the Developer Options tab, first we need to right click on the Home, click on the Customize the Ribbon button and that leads to a Dialog Box.<\/p>\nStep 2: <\/strong>From the Customize the Ribbon tab, check the Developer Options to enable the Developer tab and then click Ok.<\/p>\n![\"Developer](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Developer-dialog.png\")
<\/a><\/p>\n <\/p>\n
Step 3:<\/strong> Here, you find the Developer tab being enabled in the ribbon.<\/p>\n![\"Developer](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Developer-1.png\")
<\/a><\/p>\nNote<\/strong>: To remove the developer tab from the sheet, follow the same steps but uncheck the box beside developer option and press ok.<\/p>\nCustomization of Microsoft Excel Environment<\/h3>\n
The excel environment can be customized as per the requirement of the user. The user can change the colour theme, formulas and customizing the ribbon etc.<\/p>\n
\n- Customization the ribbon<\/li>\n
- Setting the colour theme<\/li>\n
- Settings for formulas<\/li>\n
- Proofing settings<\/li>\n
- Save settings<\/li>\n<\/ul>\n
Customization of Excel Ribbon<\/h3>\n
![\"Tabs](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/tabs.png\")
<\/a><\/p>\nIf the user wants to add some tabs that are missing or to remove some tab, follow the steps:<\/p>\n
Step – 1: Click on the file tab.<\/p>\n
Step – 2: Select options from the list.<\/p>\n
Note: An Excel Options dialog window appears.<\/p>\n
Step – 3: Choose the customize ribbon option from the panel.<\/p>\n
![\"customize](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/customize-the-ribbon.png\")
<\/a><\/p>\nStep – 4: On the right-hand side, remove the check marks from the tabs that the user doesn’t require on the ribbon.<\/p>\n
Step – 5: Click on the “OK” button.<\/p>\n
Adding custom tabs to the ribbon in Excel<\/h3>\n
The user can also add their own tab, give it a custom name and assign commands as required. Let’s add a tab to the ribbon with the text DataFlair. To add custom tabs, follow the steps:<\/p>\n
Step – 1: Click on the file tab.
\nStep – 2: Select options from the list.
\nNote: An Excel Options dialog window appears
\nStep – 3: Choose the customize ribbon option from the panel.
\nStep – 4: Click on the new tab button and rename it accordingly.
\nStep – 5: Add the commands required to the newly created tab.
\nStep – 6: Click on the ok button.<\/p>\n
![\"new](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/new-tab-in-rib.png\")
<\/a><\/p>\nYour ribbon appears as follows:<\/p>\n
![\"Customize](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/dataflair-in-ribbon.png\")
<\/a><\/p>\nSetting the color theme in Excel<\/h3>\n
To set the color theme for the Excel sheet, the user has to go to the Excel ribbon, and click on the File tab and choose the option command. It will open a dialog window. To set the colour theme, follow the steps:<\/p>\n
![\"color](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/color-theme.png\")
<\/a><\/p>\nStep – 1: Go to the general tab from the panel.
\nStep – 2: Click on the colour scheme under General options.
\nStep – 3: Click on the drop-down list and select the colour which is required.
\nStep – 4: Click on the OK button.<\/p>\n
Settings for Excel formulas<\/h3>\n
This option allows the user to define how Excel behaves when they are working with the formulas. The user can use it to autocomplete when entering formulas, change the cell referencing style etc.<\/p>\n
![\"formulas](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/formulas.png\")
<\/a><\/p>\nIf the user wants to activate an option, click on the check box. If the user wants to deactivate an option, remove the mark from the checkbox. The user can use this option from the options dialog window and go to the formulas tab from the panel.<\/p>\n
Excel Proof settings<\/h3>\n
![\"Proof](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/proof-settings.png\")
<\/a><\/p>\nThis proof setting helps the user to manipulate the entered text in the cell. It allows the settings options to check for the wrong spellings, suggestions from the dictionary, etc. The user can use this option from the options dialog window and go to the proofing tab from the panel.<\/p>\n
Color Theme Setting:<\/h4>\n
You can also set color theme for your excel and you can set it by following the steps:
\nStep \u2013 1: Click on the file tab and choose general.
\nStep \u2013 2: Go to the office theme and select the desired color from the drop down list.
\nStep \u2013 3: Press ok.<\/p>\n
![\"Color](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/color-settings.png\")
<\/a><\/p>\nWhat is a Quick Access Toolbar?<\/h3>\n
The frequently used commands at the top of the application window are known as the quick access toolbar. These commands are accessed at any part of the application and it is not dependent on the ribbon tab which is opened.<\/p>\n
The quick access toolbar is a drop-down menu containing a set of commands. It also includes an option to add the user\u2019s own commands. There is no limit in the number of commands in the quick access toolbar and also the commands which are visible depending on the size of the window.<\/p>\n
![\"Quick](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/quick-access.png\")
<\/a><\/p>\nUndo Changes<\/h3>\n
Using the Undo command, the user can reverse the actions in MS Excel. To undo changes, follow the step:<\/p>\n
\n- Click on the undo icon from the quick access toolbar.<\/li>\n
- Or else press Ctrl+Z.<\/li>\n<\/ul>\n
![\"undo](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/undo.png\")
<\/a><\/p>\nNote: The user can reverse nearly 100 past actions that are performed by executing undo more than once. The list of the actions appears when the user clicks on the arrow button. Click an item from the list to undo that particular action.<\/p>\n
![\"Excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/zoom-img.png\")
<\/a><\/p>\nRedo Changes<\/h3>\n
The user can also reverse back the action by clicking on the Redo icon.
\nTo Redo changes, follow the steps:<\/p>\n
\n- Click on the redo icon from the quick access toolbar.<\/li>\n
- Or else press Ctrl + Y.<\/li>\n<\/ul>\n
![\"Redo](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/Redo-img.png\")
<\/a><\/p>\nThere are three ways to Customize the Quick Access Toolbar window<\/p>\n
Method – 1<\/strong>: Click on the file tab, select options and go to the quick access toolbar. Add the required options to the quick access toolbar and finally press the ok button.<\/p>\n![\"quick](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/quick-access-options.png\")
<\/a><\/p>\nMethod – 2:<\/strong> Place the cursor anywhere on the ribbon, right click and select the customize quick access toolbar.<\/p>\n![\"customise](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/customise-method-2.png\")
<\/a><\/p>\nMethod – 3:<\/strong> Click on the down arrow at the top of the excel sheet. The down arrow is the quick access toolbar icon. Choose More Commands from the menu.<\/p>\n![\"Customize](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/method-3.png\")
<\/a><\/p>\nNote: The dialog window appears and the user can add, remove and reorder the quick access toolbar commands.<\/p>\n
How to add a command button to Quick Access Toolbar?<\/h3>\n
To enable command from the quick access toolbar, follow the steps:<\/p>\n
Step 1<\/strong>: Click on the Customize Quick Access Toolbar button from the excel file.<\/p>\nStep 2<\/strong>: Enable the command that you want to see in the quick access toolbar menu.<\/p>\nFor example:<\/strong> If the user wants to enable the spell check, select the spelling option from the list and immediately the button appears in the quick access toolbar.<\/p>\n![\"Quick](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/quick-button.png\")
<\/a><\/p>\nHow to remove a command from Quick Access Toolbar?<\/h3>\n
To remove a command from the Quick Access Toolbar, right-click on the toolbar and select Remove from Quick Access Toolbar from the menu:<\/p>\n
![\"remove](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/remove-from-quick.png\")
<\/a><\/p>\nHow to rearrange commands on Quick Access Toolbar?<\/h3>\n
To rearrange commands, follow the steps:<\/p>\n
Step 1: Right-click on the toolbar and select the customize Quick Access Toolbar from the menu.<\/p>\n
Step 2: Select the command that the user wants to move and click the Move Up or Move Down arrow.<\/p>\n
For example, the user wants to move the spelling above the quick print, select it and click on the up arrow.<\/p>\n
![\"Rearrange](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/reset-qat.png\")
<\/a><\/p>\nStep 3: Press the OK button.<\/p>\n
Group commands on Quick Access Toolbar<\/h3>\n
If there are alot of commands, the user may want to sub-divide the functions into logical groups.
\nThough the Quick Access Toolbar does not allow creating groups like on the Excel ribbon, the user can group commands by adding a separate group tab. To add a group commands on Quick Access Toolbar, follow the steps:<\/p>\n
Step 1: Right-click on the toolbar and select the customize Quick Access Toolbar from the menu.<\/p>\n
Step 2: Choose commands in the dialog window and select popular commands.<\/p>\n
Step 3: Choose the <Separator> option and click on the Add.<\/p>\n
Step 4: Press on the Move Up or Move Down arrow to position the separator.<\/p>\n
Step 5: Press the OK button.<\/p>\n
![\"separator](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/seperator.png\")
<\/a><\/p>\nCustomizing the Quick Access Toolbar only for the current workbook<\/h3>\n
When the user customizes the quick access toolbar in excel, it is customized for all the workbooks by default. But if the user likes to make certain customizations for one particular workbook then select the current workbook from the customize quick access toolbar and then add the commands as required.<\/p>\n
![\"Single](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/single-sheet-qat.png\")
<\/a><\/p>\nNote: The customizations made for the worksheet does not replace the other quick access toolbar commands. The customized commands are added to it.<\/p>\n
How to move the Quick Access Toolbar below or above the ribbon?<\/h3>\n
Quick Access Toolbar is situated at the top of the excel window and it is the default location of it. If the user finds it comfortable to have the ribbon below, then they can move it.<\/p>\n
To move the Quick Access Toolbar below, follow the steps<\/p>\n
Step 1: Click on the Customize Quick Access Toolbar button from the ribbon.<\/p>\n
Step 2: Select the show below the ribbon option.<\/p>\n
![\"Show](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/show-below.png\")
<\/a><\/p>\nNote: To get the Quick Access Toolbar back to the previous location, click on the Customize Quick Access Toolbar button and then choose the Show Above the Ribbon option from the menu.<\/p>\n
How to reset the Quick Access Toolbar to the default settings?<\/h3>\n
To reset the Quick Access Toolbar to the default settings, follow the steps:<\/p>\n
Step 1: Right-click on the toolbar and select the customize Quick Access Toolbar from the menu.<\/p>\n
Step 2: Click on the Reset button and then choose Reset only Quick Access Toolbar.<\/p>\n
![\"Reset](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/reset-qat-1.png\")
<\/a><\/p>\nStep 3: Press the OK button.<\/p>\n
Export and import a custom Quick Access Toolbar<\/h3>\n
Microsoft Excel allows the user to save the Quick Access Toolbar and ribbon customizations into a file and this file can be imported later. This can help the user to keep the Excel interface looking the same on all the computers that the user uses as well as share the customizations with the other Excel users if they want.<\/p>\n
\n- Export a customized Quick Access Toolbar:<\/strong>
\nTo export a customized Quick Access Toolbar, click on the Export all customizations under customizations and save the customizations file to a folder.<\/li>\n- Import a customized Quick Access Toolbar:<\/strong>
\nGo to the Customize the Quick Access Toolbar window, choose Import\/ Export and select the Import customization file from the option. The user can browse for the customizations file which was saved earlier.<\/li>\n<\/ul>\n![\"import](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/import-export.png\")
<\/a><\/p>\nNote:<\/strong>
\nThe file that the user exports and imports also includes the ribbon customizations. There is no other way to export or import only the Quick Access Toolbar from the sheet.<\/p>\nWhen the user imports the customizations file to a system, all prior ribbon and the quick access toolbar customizations on that system are permanently lost. To be able to restore the current customizations, be sure to export it and save as a backup copy before importing any new customizations to the system.<\/p>\n
Adding custom tabs to the ribbon in Excel<\/h3>\n
The user can also add their own tab, give it a custom name and assign commands as required. Let’s add a tab to the ribbon with the text DataFlair. To add custom tabs, follow the steps:<\/p>\n
Step – 1: Click on the file tab.<\/p>\n
Step – 2: Select options from the list.<\/p>\n
Note: An Excel Options dialog window appears<\/p>\n
Step – 3: Choose the customize ribbon option from the panel.<\/p>\n
Step – 4: Click on the new tab button and rename it accordingly.<\/p>\n
Step – 5: Add the commands required to the newly created tab.<\/p>\n
Step – 6: Click on the ok button.<\/p>\n
![\"new](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/new-tab-in-rib-1.png\")
<\/a><\/p>\nYour ribbon appears as follows:<\/p>\n
![\"Excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/dataflair-in-ribbon-1.png\")
<\/a><\/p>\nExcel Status Bar<\/h3>\n
Status bar appears at the bottom of the sheet and it’s quite useful as it displays the average, count, sum, etc of the selected cell.<\/p>\n
For a sample, let’s select the range A2:A6 in the sheet. Have a look at the status bar to see the average, count and sum of these cells.<\/p>\n
![\"Excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/a2a6.png\")
<\/a><\/p>\nNote: The status bar options are chosen by default. Right-click on the status bar to activate even more options to view in the status bar.<\/p>\n
To view more options, follow the steps:<\/p>\n
Step 1: Right-click on the status bar.<\/p>\n
Step 2: Click on the required options. Here, we are choosing the maximum and minimum.<\/p>\n
![\"max](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/max-min-status-bar.png\")
<\/a><\/p>\nNote: Excel displays the minimum and maximum values also in the status bar.<\/p>\n
![\"Max](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/max-min-op.png\")
<\/a><\/p>\nNote: Excel uses the status bar in many situations and if the user does not want to view it, then they can hide it.<\/p>\n
Checkbox in Excel<\/h3>\n
Inserting a checkbox and check mark in Excel is simple and easy. For example, let\u2019s use a checkbox to create it in B2 cell.<\/p>\n
Inserting a Checkbox<\/h4>\n
To insert a checkbox, follow the steps.<\/p>\n
Step 1: Click on the developer tab and select the insert icon.<\/p>\n
![\"Insert](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/insert-option.png\")
<\/a><\/p>\nStep 2: Choose the Check Box from the Form Controls section.<\/p>\n
![\"check](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/check-box.png\")
<\/a><\/p>\nStep 3: Place the cursor on the B2 cell and draw the checkbox.<\/p>\n
![\"Check](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/cb1.png\")
<\/a><\/p>\nStep 4. To remove “Check Box 1”, right-click on the checkbox, select the text and delete it.<\/p>\n
![\"remove](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/remove-txt.png\")
<\/a><\/p>\nLink a Checkbox<\/h4>\n
To link a checkbox to a cell, follow the steps.<\/p>\n
Step 1: Right-click on the checkbox and choose Format Control.<\/p>\n
![\"Format](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/format-control.png\")
<\/a><\/p>\nStep 2: Link the checkbox to the required cell. Here, it is C2.<\/p>\n
There are four components in excel ribbon and they are tabs, groups, dialog launchers and command buttons.<\/p>\n
It contains multiple commands which are logically split into groups.<\/p>\n It is a group of commands which are closely related and they are performed as a part of larger tasks.<\/p>\n It is a small arrow in the right corner of a group which brings up more related commands. It appears in the group’s right corner as a small icon.<\/p>\n It is the button a user clicks to perform a particular action.<\/p>\n There are few tabs available in the ribbons such as File, Home, Insert, Draw, Page layout, Formulas, Data, etc.<\/p>\n It navigates the user to the backstage view which contains the information about the file and the excel options . It was introduced in the excel 2010 version as a replacement to the office button in excel 2007 and in earlier versions.<\/p>\n This tab contains the most frequently used commands in it.<\/p>\n This tab adds different objects and charts in the spreadsheet such as Images, PivotTables, Charts, Symbols, Headers, etc.<\/p>\n This tab appears based on the device the user uses. This lets the user draw with the digital pen, mouse. This tab is available from the version Excel 2013 and so on. But this tab is not visible like the developer tab by default.<\/p>\n This tab provides the tool to the users to manage the worksheet appearance. This tab contains tools such as gridlines, page margins, object aligning, print area, etc.<\/p>\n This tab contains the tools for inserting the functions or formulas in the cell.<\/p>\n This tab provides the commands for managing the data even while connecting to the external data.<\/p>\n This tab provides the tools such as check spelling, add commands, protects worksheets and workbooks ,etc.<\/p>\n This tab provides the commands for switching between the worksheet views and arranging the multiple windows etc.<\/p>\n This tab is available in the excel 2019 and office 365 versions. The help tab provides quick access to the help task pane and allows the user to contact Microsoft support.<\/p>\n This tab provides access to the advanced features in excel such as macros, form controls and XML commands. This tab is not visible until the user enables it.<\/p>\n The excel ribbon also has context-sensitive tabs which are also known as tool tabs. This shows up only when the users select a certain item such as tables, charts, shapes, etc.<\/p>\n For example, if the user selects a chart, then the design and format tab appears under the chart tools.<\/p>\n The user can also minimize the ribbon by clicking on the symbol near the minimize symbol and then choose the auto-hide ribbon option.<\/p>\n Auto-hide shows the workbook in full-screen mode and once this option is chosen, it completely hides the Ribbon. To show the Ribbon again, click on the Expand Ribbon command at the top of the screen( three dots).<\/p>\n Show Tabs:<\/strong> When you click on this option, it hides all command groups when not in use, but the tab will remain clear. Simply click on the tab to maximize the ribbon.<\/p>\n Show Tabs and Commands:<\/strong> When you click on this option, it will maximize the Ribbon. All of the tabs and commands will be clear when this option is chosen.<\/p>\n The user can collapse the ribbon to increase the size of the worksheet on the screen. When the user clicks on the collapse option, it hides the tabs and commands. To collapse the ribbon, right click anywhere on the ribbon and then select Collapse the Ribbon option.<\/p>\n Note: When the user chooses the collapse option, the result appears as follows<\/p>\n If the user wants to make the ribbon be visible back again in the excel, then click on that small icon at the right side of the sheet and select show tabs and commands option.<\/p>\n Note: When the user chooses the Show tabs and commands option, the result appears as follows: If the user wishes to personalize the ribbon for their needs then they can also do that now. The entry point to most customizations is the Customize Ribbon window under the Excel Options. The shortest path to customize the ribbon is to right-click on the ribbon and select Customize the Ribbon from the menu.<\/p>\n You can also customize the ribbon and to do that, follow the steps: You can also customize the tabs on the ribbon. To do so, follow the steps: The developer tab is an additional tab to the excel ribbon and this tab allows the user to access the advanced features such as Form controls, VBA Macros etc. The one disadvantage is that the Developer tab is hidden by default. But it’s very easy to enable it.<\/p>\n Developer Options<\/strong><\/p>\n Step 1: <\/strong>To get the Developer Options tab, first we need to right click on the Home, click on the Customize the Ribbon button and that leads to a Dialog Box.<\/p>\n Step 2: <\/strong>From the Customize the Ribbon tab, check the Developer Options to enable the Developer tab and then click Ok.<\/p>\n <\/p>\n Step 3:<\/strong> Here, you find the Developer tab being enabled in the ribbon.<\/p>\n Note<\/strong>: To remove the developer tab from the sheet, follow the same steps but uncheck the box beside developer option and press ok.<\/p>\n The excel environment can be customized as per the requirement of the user. The user can change the colour theme, formulas and customizing the ribbon etc.<\/p>\n If the user wants to add some tabs that are missing or to remove some tab, follow the steps:<\/p>\n Step – 1: Click on the file tab.<\/p>\n Step – 2: Select options from the list.<\/p>\n Note: An Excel Options dialog window appears.<\/p>\n Step – 3: Choose the customize ribbon option from the panel.<\/p>\n Step – 4: On the right-hand side, remove the check marks from the tabs that the user doesn’t require on the ribbon.<\/p>\n Step – 5: Click on the “OK” button.<\/p>\n The user can also add their own tab, give it a custom name and assign commands as required. Let’s add a tab to the ribbon with the text DataFlair. To add custom tabs, follow the steps:<\/p>\n Step – 1: Click on the file tab. Your ribbon appears as follows:<\/p>\n To set the color theme for the Excel sheet, the user has to go to the Excel ribbon, and click on the File tab and choose the option command. It will open a dialog window. To set the colour theme, follow the steps:<\/p>\n Step – 1: Go to the general tab from the panel. This option allows the user to define how Excel behaves when they are working with the formulas. The user can use it to autocomplete when entering formulas, change the cell referencing style etc.<\/p>\n If the user wants to activate an option, click on the check box. If the user wants to deactivate an option, remove the mark from the checkbox. The user can use this option from the options dialog window and go to the formulas tab from the panel.<\/p>\n This proof setting helps the user to manipulate the entered text in the cell. It allows the settings options to check for the wrong spellings, suggestions from the dictionary, etc. The user can use this option from the options dialog window and go to the proofing tab from the panel.<\/p>\n You can also set color theme for your excel and you can set it by following the steps: The frequently used commands at the top of the application window are known as the quick access toolbar. These commands are accessed at any part of the application and it is not dependent on the ribbon tab which is opened.<\/p>\n The quick access toolbar is a drop-down menu containing a set of commands. It also includes an option to add the user\u2019s own commands. There is no limit in the number of commands in the quick access toolbar and also the commands which are visible depending on the size of the window.<\/p>\n Using the Undo command, the user can reverse the actions in MS Excel. To undo changes, follow the step:<\/p>\n Note: The user can reverse nearly 100 past actions that are performed by executing undo more than once. The list of the actions appears when the user clicks on the arrow button. Click an item from the list to undo that particular action.<\/p>\n The user can also reverse back the action by clicking on the Redo icon. There are three ways to Customize the Quick Access Toolbar window<\/p>\n Method – 1<\/strong>: Click on the file tab, select options and go to the quick access toolbar. Add the required options to the quick access toolbar and finally press the ok button.<\/p>\n Method – 2:<\/strong> Place the cursor anywhere on the ribbon, right click and select the customize quick access toolbar.<\/p>\n Method – 3:<\/strong> Click on the down arrow at the top of the excel sheet. The down arrow is the quick access toolbar icon. Choose More Commands from the menu.<\/p>\n Note: The dialog window appears and the user can add, remove and reorder the quick access toolbar commands.<\/p>\n To enable command from the quick access toolbar, follow the steps:<\/p>\n Step 1<\/strong>: Click on the Customize Quick Access Toolbar button from the excel file.<\/p>\n Step 2<\/strong>: Enable the command that you want to see in the quick access toolbar menu.<\/p>\n For example:<\/strong> If the user wants to enable the spell check, select the spelling option from the list and immediately the button appears in the quick access toolbar.<\/p>\n To remove a command from the Quick Access Toolbar, right-click on the toolbar and select Remove from Quick Access Toolbar from the menu:<\/p>\n To rearrange commands, follow the steps:<\/p>\n Step 1: Right-click on the toolbar and select the customize Quick Access Toolbar from the menu.<\/p>\n Step 2: Select the command that the user wants to move and click the Move Up or Move Down arrow.<\/p>\n For example, the user wants to move the spelling above the quick print, select it and click on the up arrow.<\/p>\n Step 3: Press the OK button.<\/p>\n If there are alot of commands, the user may want to sub-divide the functions into logical groups. Step 1: Right-click on the toolbar and select the customize Quick Access Toolbar from the menu.<\/p>\n Step 2: Choose commands in the dialog window and select popular commands.<\/p>\n Step 3: Choose the <Separator> option and click on the Add.<\/p>\n Step 4: Press on the Move Up or Move Down arrow to position the separator.<\/p>\n Step 5: Press the OK button.<\/p>\n When the user customizes the quick access toolbar in excel, it is customized for all the workbooks by default. But if the user likes to make certain customizations for one particular workbook then select the current workbook from the customize quick access toolbar and then add the commands as required.<\/p>\n Note: The customizations made for the worksheet does not replace the other quick access toolbar commands. The customized commands are added to it.<\/p>\n Quick Access Toolbar is situated at the top of the excel window and it is the default location of it. If the user finds it comfortable to have the ribbon below, then they can move it.<\/p>\n To move the Quick Access Toolbar below, follow the steps<\/p>\n Step 1: Click on the Customize Quick Access Toolbar button from the ribbon.<\/p>\n Step 2: Select the show below the ribbon option.<\/p>\n Note: To get the Quick Access Toolbar back to the previous location, click on the Customize Quick Access Toolbar button and then choose the Show Above the Ribbon option from the menu.<\/p>\n To reset the Quick Access Toolbar to the default settings, follow the steps:<\/p>\n Step 1: Right-click on the toolbar and select the customize Quick Access Toolbar from the menu.<\/p>\n Step 2: Click on the Reset button and then choose Reset only Quick Access Toolbar.<\/p>\n Step 3: Press the OK button.<\/p>\n Microsoft Excel allows the user to save the Quick Access Toolbar and ribbon customizations into a file and this file can be imported later. This can help the user to keep the Excel interface looking the same on all the computers that the user uses as well as share the customizations with the other Excel users if they want.<\/p>\n Note:<\/strong> When the user imports the customizations file to a system, all prior ribbon and the quick access toolbar customizations on that system are permanently lost. To be able to restore the current customizations, be sure to export it and save as a backup copy before importing any new customizations to the system.<\/p>\n The user can also add their own tab, give it a custom name and assign commands as required. Let’s add a tab to the ribbon with the text DataFlair. To add custom tabs, follow the steps:<\/p>\n Step – 1: Click on the file tab.<\/p>\n Step – 2: Select options from the list.<\/p>\n Note: An Excel Options dialog window appears<\/p>\n Step – 3: Choose the customize ribbon option from the panel.<\/p>\n Step – 4: Click on the new tab button and rename it accordingly.<\/p>\n Step – 5: Add the commands required to the newly created tab.<\/p>\n Step – 6: Click on the ok button.<\/p>\n Your ribbon appears as follows:<\/p>\n Status bar appears at the bottom of the sheet and it’s quite useful as it displays the average, count, sum, etc of the selected cell.<\/p>\n For a sample, let’s select the range A2:A6 in the sheet. Have a look at the status bar to see the average, count and sum of these cells.<\/p>\n Note: The status bar options are chosen by default. Right-click on the status bar to activate even more options to view in the status bar.<\/p>\n To view more options, follow the steps:<\/p>\n Step 1: Right-click on the status bar.<\/p>\n Step 2: Click on the required options. Here, we are choosing the maximum and minimum.<\/p>\n Note: Excel displays the minimum and maximum values also in the status bar.<\/p>\n Note: Excel uses the status bar in many situations and if the user does not want to view it, then they can hide it.<\/p>\n Inserting a checkbox and check mark in Excel is simple and easy. For example, let\u2019s use a checkbox to create it in B2 cell.<\/p>\n To insert a checkbox, follow the steps.<\/p>\n Step 1: Click on the developer tab and select the insert icon.<\/p>\n Step 2: Choose the Check Box from the Form Controls section.<\/p>\n Step 3: Place the cursor on the B2 cell and draw the checkbox.<\/p>\n Step 4. To remove “Check Box 1”, right-click on the checkbox, select the text and delete it.<\/p>\n To link a checkbox to a cell, follow the steps.<\/p>\n Step 1: Right-click on the checkbox and choose Format Control.<\/p>\n Step 2: Link the checkbox to the required cell. Here, it is C2.<\/p>\n<\/a><\/p>\nRibbon Tab :<\/h4>\n
Ribbon Group:<\/h4>\n
Dialog Launcher :<\/h4>\n
Command Button:<\/h4>\n
Ribbon Tabs in Excel<\/h3>\n
File:<\/h4>\n
Home:<\/h4>\n
Insert:<\/h4>\n
Draw:<\/h4>\n
Page Layout:<\/h4>\n
Formulas:<\/h4>\n
Data:<\/h4>\n
Review:<\/h4>\n
View:<\/h4>\n
Help:<\/h4>\n
Developer:<\/h4>\n
Contextual Ribbon Tabs:<\/h3>\n
<\/a><\/p>\nHow to hide the Ribbon in Excel?<\/h3>\n
Minimizing the ribbon<\/h4>\n
<\/a><\/p>\nAuto-hide Ribbon:<\/h4>\n
<\/a><\/p>\nCollapse the Ribbon in Excel<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nExpand the Excel ribbon<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nHow to customize Excel ribbon?<\/h3>\n
Customizing the Ribbon in Excel:<\/h4>\n
\nStep – 1: Click on the File tab
\nStep – 2: Choose options
\nStep- 3: Click on the customize the ribbon option from the left side of the panel.
\nStep – 4: Customize the ribbon by adding the required commands.
\nStep – 5: Once done, click on the ok button.<\/p>\n<\/a><\/p>\nAdding custom tabs on the ribbon:<\/h4>\n
\nStep \u2013 1: Click on the file tab and choose options.
\nStep \u2013 2: Select customize the ribbon option from the left side of the panel.
\nStep \u2013 3: Click on the new tab button and the new tab appears in the list.
\nStep \u2013 4: Right click on it and rename the tab.
\nStep \u2013 5: Select the New Group (Custom) under the new tab.
\nStep \u2013 6: Add commands to the ribbon bar.
\nStep \u2013 7: Click on the ok button.<\/p>\n<\/a><\/p>\nHow to show the Developer tab in Excel?<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nCustomization of Microsoft Excel Environment<\/h3>\n
\n
Customization of Excel Ribbon<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nAdding custom tabs to the ribbon in Excel<\/h3>\n
\nStep – 2: Select options from the list.
\nNote: An Excel Options dialog window appears
\nStep – 3: Choose the customize ribbon option from the panel.
\nStep – 4: Click on the new tab button and rename it accordingly.
\nStep – 5: Add the commands required to the newly created tab.
\nStep – 6: Click on the ok button.<\/p>\n<\/a><\/p>\n<\/a><\/p>\nSetting the color theme in Excel<\/h3>\n
<\/a><\/p>\n
\nStep – 2: Click on the colour scheme under General options.
\nStep – 3: Click on the drop-down list and select the colour which is required.
\nStep – 4: Click on the OK button.<\/p>\nSettings for Excel formulas<\/h3>\n
<\/a><\/p>\nExcel Proof settings<\/h3>\n
<\/a><\/p>\nColor Theme Setting:<\/h4>\n
\nStep \u2013 1: Click on the file tab and choose general.
\nStep \u2013 2: Go to the office theme and select the desired color from the drop down list.
\nStep \u2013 3: Press ok.<\/p>\n<\/a><\/p>\nWhat is a Quick Access Toolbar?<\/h3>\n
<\/a><\/p>\nUndo Changes<\/h3>\n
\n
<\/a><\/p>\n<\/a><\/p>\nRedo Changes<\/h3>\n
\nTo Redo changes, follow the steps:<\/p>\n\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nHow to add a command button to Quick Access Toolbar?<\/h3>\n
<\/a><\/p>\nHow to remove a command from Quick Access Toolbar?<\/h3>\n
<\/a><\/p>\nHow to rearrange commands on Quick Access Toolbar?<\/h3>\n
<\/a><\/p>\nGroup commands on Quick Access Toolbar<\/h3>\n
\nThough the Quick Access Toolbar does not allow creating groups like on the Excel ribbon, the user can group commands by adding a separate group tab. To add a group commands on Quick Access Toolbar, follow the steps:<\/p>\n<\/a><\/p>\nCustomizing the Quick Access Toolbar only for the current workbook<\/h3>\n
<\/a><\/p>\nHow to move the Quick Access Toolbar below or above the ribbon?<\/h3>\n
<\/a><\/p>\nHow to reset the Quick Access Toolbar to the default settings?<\/h3>\n
<\/a><\/p>\nExport and import a custom Quick Access Toolbar<\/h3>\n
\n
\nTo export a customized Quick Access Toolbar, click on the Export all customizations under customizations and save the customizations file to a folder.<\/li>\n
\nGo to the Customize the Quick Access Toolbar window, choose Import\/ Export and select the Import customization file from the option. The user can browse for the customizations file which was saved earlier.<\/li>\n<\/ul>\n<\/a><\/p>\n
\nThe file that the user exports and imports also includes the ribbon customizations. There is no other way to export or import only the Quick Access Toolbar from the sheet.<\/p>\nAdding custom tabs to the ribbon in Excel<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nExcel Status Bar<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nCheckbox in Excel<\/h3>\n
Inserting a Checkbox<\/h4>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nLink a Checkbox<\/h4>\n
<\/a><\/p>\n