Hi, everyone.
If you want to add developer ribbon tab to your interface, what would you do?
Well, this is take us to learn a new feature and the new technique about customization, interface
customization in Microsoft Excel.
So we will learn today an important thing.
It's about customize the ribbons.
You can click on any ribbon group and select, customize the ribbon or you can use it more options and
select customized Drebin.
So this is all ribbons in Excel.
In the previous lecture, we have learned to use quick access toolbar and we have learned to add or
remove any command in quick access toolbar.
And there are several commands and quick exit toolbar such as Save, Undo, Redo and Open.
Now we want to answer the question, this question, how to add the ribbon so we will use customized
ribbon.
So customized ribbon have made taps and all types and tool taps from many taps.
You can add or remove any ribbon tab by check or uncheck in this tab.
For example, if you want to delete old old taps in the TAP toolbar, you can just check on them.
So if you want to check insert page layout, formula data, if you view ons help home.
And OK, so no taps here.
Altered or disappeared, if you want to add this tab again, five more options, customized ribbon and
check all these steps.
Here is but the question is, how can I add developer tab to my tab ribbons, right.
Click from here, customize it or find more options.
Customized ribbon and check on developer, this devil worship.
OK.
Here is the tape and we will discuss this tape in detail in the advanced stage of this course.
Well.
What about customized ribbon?
What about the other features and the other options and customizable so you can make a new step by adding
Newtek and rename the step?
I can't really make by smartphone.
OK.
And you can rhenium also Euterpe.
By Smardon.
So I have created a new tab called Smart, that and new Reben group called Smarter and I can add any
comment I want to use.
So if I want to add full color to this Raven Group, just add full color.
I can add, for example, borders, and I want to add also save add.
So I make a new step with a new ribbon group with a new three commonly used commanders based on my using
Microsoft Excel.
And these commands are full color borders safe.
OK.
So this is our new test, Smarter Tap, and this is our new reading group, Smarter, and this is the
selected commanders here.
We have selected from customized ribbon, and by this way, I can change o the face and the default
interface of Microsoft Excel by adding and removes commands, steps, ribbons.
This is customization, great customization.
I can reformulate all this interface based on my use.
And this is the power of ribbon customization.
OK, this is our commanders and this is all commanders, this is commanders not in the ribbon.
This is macro commanders and this is fight step and this is all taps and this is main taps and this
tool taps and customized and group.
So it's powerful.
Moreover, what if I want to save the theme or this customization?
Can I save them or report them to a file?
And can I use the theme again to automatically report it to another Excel sheet?
Of course, you can't save this seam by export all customizations.
You will export all customization file to your desktop, for example, and to save.
So this will have that customized ribbons based on your views, you can import this customization to
any other Excel sheet, to any other personal computer.
So just go to Excel, right?
Click customize the ribbon and import this customization and both customization, file desktop and select
and replace all existing existing ribbon and quick access toolbar customization for this program.
Yes.
If you do if you click yes, then you have imported this customization.
This is about customizer, even this about how to reformulate and reinvent the exel interface and use
the common commands based on your own usage.
Thank you and see you in the next lecture.