Рет қаралды 526,363
This Video is about How to make own Customizing Ribbon or software in MS Excel.
or
you can say How to set up Microsoft Excel's Ribbon in an easy way?
You can customize the Ribbon by creating your own tabs with whichever command you want. Commands are always housed within a group, and you can create as many groups as you want in order to keep your tab organized. If you want, you can even add commands to any of the default tabs, as long as you create a custom group in the tab.
Below are few steps to complete this task as soon.
1.Click File.
2.Select Options.
3.Select Customize Ribbon.
The Options screen, though intimidating, is actually quite simple to navigate. The left column (Choose commands from) contains nine lists of commands and tabs to browse through while the right column (Customize the Ribbon) lists what is on your ribbon. You can select commands and tabs from the left column and click the button to move them into the right column to display in the Ribbon, or select displayed items in the right column and click the button to remove them. You do have a few limitations to keep in mind as come commands must not be altered or removed. Let's see how you can customize the Ribbon.
How to add a command
1.Click File.
2.Select Options.
3.Select Customize Ribbon.
4.Select a command inside the Choose commands from list.
5.Click on the command.
6.Click on Add.
7.Click OK for the addition to take effect.
How to remove a command
1.Click File.
2.Select Options.
3.Select Customize Ribbon.
4.Click on the command.
5.Select Remove.
Individual commands cannot be added to existing tabs or groups. You can create a custom group in an existing tab or a subgroup of a group. This will then allow you to add commands.
How to add a Custom Tab
1.Click File.
2.Select Options.
3.Select Customize Ribbon.
4.Click New Tab.
5.Click OK to save.
Import and Export Ribbons
If your team seems to use the same commands in Excel 2016, you may choose to import their Ribbons or export your own to them.
Wrapping Up
You do not have to understand all of the commands to understand the functionality of the Ribbon. It is meant to help you understand the relationships between the commands as well as help you create new relationships. You know how you truly work to let the Excel 2016 Ribbon become your own. Do you use the Ribbon in Excel? How you left it in its default view or have you added your own customization? Let us know!
~~~~~~~~Please Watch Our More Popular Videos~~~~~~
All Excel Lookup 2017 Series in Hindi
• Why we Use True and Fa...
Using Dollar ($) Sign in Excel Formula│Absolute, Relative and Mixed Cell Referencing in Excel -HINDI
• Using Dollar ($) Sign ...
Double Vlookup in Ms-Excel in HINDI - PART 1
• Double Vlookup in Ms-E...
Split Full Name to FIRST, MIDDLE and LAST Name in Excel with Formula│LEFT RIGHT MID and FIND Formula
• Split Full Name to FIR...
Fuzzy lookup add in Excel│Remove Duplicate and Spelling Mistake from Fuzzy lookup
• Fuzzy lookup add in Ex...
Excel Expert Tips and Tricks -Excel Secret you don't know│cool excel tricks│best excel tips in HINDI
• Excel Expert Tips and ...
Vlookup true false formula l How to USE vlookup in Excel
• Why we Use True and Fa...
Search box in Excel, create a search box in excel with condition formatting, Excel search box-HINDI
• Search box in Excel│cr...
How to Hide WhatsApp Videos and Images from Mobile Gallery - Nomedia Android WhatsApp Trick - HINDI
www.youtube.co....
Mobile Number Validation for 10 Digit, MS-Excel Phone Number Validation Formatting in HINDI
www.youtube.co....
LIKE | COMMENT | SHARE | SUBSCRIBE
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u