[Music] this time we are going to learn how to create an interactive side menu in your Microsoft Excel document, this side menu will not need macros or programming, we are going to do it in a super simple way so that you can create this type of side menus that I have here on the left, well, look, there are five little buttons, the main client, product, sales and purchases, you can add the menus you want suddenly, these five are very few, here I am going to show you how you can add ns, I could say menus, well, I'm going to give a click, for example , on clients and look how I change the page I click on products I also change the page sales purchases and so on and I can navigate look I can navigate the Excel sheets This is the menu that we are going to learn to create the one that is here you can change the color you can change the icon you can change the type of font etc. well That is what we are going to do today but before please if this v video you like subscribe to our channel by clicking where it says subscribe and activating the bell so you don't miss any news okay Let's start Now yes with this I am going to open a blank Excel we are going to do it from scratch look Here is my Excel we are going to wait a few seconds and now the first thing I am going to do is save look I am going to save file save as examine and we are going to save it well in the location that you want I am going to put it on the desktop and here I am going to put it For example, Excel 2022 menu , I will save it and now we are going to work well so that the menu stands out a little more and looks big and doesn't look too small. I'm going to put a small zoom here on the lower right, look , I'm going to give it in the most I'm going to put 210 Ok I think that's the same one that I worked here yes with 210 zoom we are going to work so that the menu looks bigger good Now yes the colors as I had told you can vary according to our taste me for example I was inspired, look, I put it here on google.com , I put the side menu, I went to images and the one I liked was this, look at this one that I'm looking at, basically this menu . What I'm going to do here is the following look I'm going to open the Power Point just look I'm going to close this I'm going to open the Power Point only to You could say locate the colors look it's a blank presentation you don't need to know Powerpoint you don't need but I I want the colors, look what I am going to do is save this image or I am going to copy the image and I am going to go to Powerpoint I give it control V I paste it and here it is I want these two colors the red and the black background So I go to the insert tab we are going to go to shapes and choose any shape I am going to choose the rectangular one I am going to a control c control V two colors look here I am going to click twice on the first shape you are going to go to shape format r shape format I fill in the form and we are going to go to the eyedropper this eyedropper tool does not have it and Word or Excel that is why it enters Powerpoint look I click here and I easily identify the color look and until the first color we go again to the second shape format shape tab shape format shape fill dropper and I am going to choose the red color there I have it look I already have the two colors that I am going to use well I select them both control c I copy them and now I take them to Excel here these are the colors that I am going to use I am going to remove the outline look twice click shape format shape outline without outline one click here shape outline without outline well what we are going to do now is look we are going to do the following we are going to give a click on in this shape that I am selecting in the brown one we are going to see to see to see to see if there is start no sorry shape format look shape format again fill shape and look let's go here to more colors One click to fill and after that, the only thing I'm going to do is accept it. Look this way, if I go back to fill the form and recent colors already appear, that is, Excel has just taken this color as recent, there I have it. We do the same with the red color, look, I click, we go to shape format, I'm going to fill the shape and I go to where it says more fill colors and I click on accept. In this way, I already have, look at the two colors with which I'm going to work here are in recent colors not only so far all I did was capture these two colors with the help of Powerpoint and then take it as recent colors in Excel Now look I select everything look I select everything column a and let's go to start and here in fill look here in fill colors here look color recent appears I click on recent color and look I already have it here on the left my first Side bar well what we are going to do now is insert let's see let's see let's see Let's see if we are going to insert the color red, we are going to click on insert, we are going to go to shapes and a rectangular shape, here I have it more or less, we are going to draw it, look, could you say the width of the cell if that is the case? Don't worry, don't look at something a little more on the envelope, you could also use it with borders. That depends on each one, not twice, click shape outline without shape fill outline and we are going to tell you that this fill is one click here okay Now I already have my Bar and I'm going to delete I'm going to delete all this what I'm going to do next Look what I'm going to do next is create the sheets that's going to be called main on the second sheet it's going to be called Let's put it as sales let's see let it be shopping here let it be products here and let it be here let's see what else we could put sales purchases products to see let's see what else I put purchases sales and customers Ok and let's put the last page as customers to see customers well now it wasn't sales look at sales as I am also going to set everyone to the same zoom 210 the same zoom to everyone Ok we could also suddenly duplicate the sheet so as not to be doing this on each sheet no That depends on each one but I am doing it on each sheet well Now yes 210 look I'm just applying zoom we come here and what we're going to do now is look I'm going to paint a group of cells I'm going to put that color for example just to distinguish it well Let's come to start insert tab insert we're going to come to shapes and we are going to choose any shape again the rectangular one this shape will be for the text Look at what I draw right click edit text and here I am going to put the main word to see very big very big and very very high no Let's see although it seems to me that's fine the main one click twice fill without fill outline without outline we have the first principal we come to insert again tab insert tab insert let's go now yes to icons icons we click on icon s and we are going to look for our first icon we are going to put for example house as it is the main one and we choose any of them look for example I am going to choose this one with its little tree I click on insert we wait a few seconds Here it is twice click we are going to go to start to see Sorry twice click graphics format and graphics format graphics fill and we are going to put the color white There we have it we make it smaller to see more or less that it stays there not there it could be well what we are going to to do next is to group well Let's group look I'm going to click look let's see Sorry sorry let's see I'm going to come here and with the control key look with the control key we are going to select the two look first I select one I press the control key select I right click on the text and we click on group group if you are wondering look now now it is a single Group if you are wondering why I put this brown background because look if I take the menu out look it disappears Ok I know d It appears that way to guide us Because later I'm going to delete it To guide us, the only thing I did was put this dark background on it. Okay, we're going to come here, we're going to bring it, look at our first menu, it's going to be called main, I'm going to copy control c, control V, to put more down control c control V there are five buttons let's see control c control V 4 control c control v and there I have it at 5 well There are the five look here what we are going to do the first thing is to link we are going to link to all the leaves I'm going to click look at each menu right click let's click on the link look Here is a clear link it says link a and we are going to put the main one This is the main one we click on accept we are going to go to the second menu click on click select we select everything right click we click on the link click on the word link not click here the little arrow Ok link click on and we click on sales we accept a click on main again right click link this is going to be called purchases We click on the main right click link this is going to be called products we accept and look at the main right click we click on the link and this is going to be called customers we accept Now we are going to go look we are going to right click right click to to be able to edit this is called look what it's called this is called sales to see sales to see sales and sales there I have it right click on the next one and this is called this is called to see it's called shopping let's right click on the next one and This is called products, products, and see, look, it was a little too small for me. That is right click, right click, if the click is not going to be activated, it will go to the sheet OK And that is called customers Now we are going to change the icons look again the same right click you click to see look now I change now I change to see a right click yes And here just look Ok look now yes we have to select only only the icon we click on the icon to see to see see to see n or it will allow me I think it will not allow me to see just look with right click Ok Look select the icon select the icon with right click and we change graphic look change graphic and here we talk about icons one click in this case it is sales We are going to put sales to see what it offers us I am going to put for example this little man insert I'm going to change I'm going to go shopping the same Let's see a right click right click look right click with pure right click if it is not activated so that they can go to another sheet and we click to see change graphics and icons and here This is look at this is shopping But we go shopping and we are going to select for example to see which one we like we are going to put this Ok insert again here in products right click on products right click on the icon change the icon graphic and here we are going to put products to see what it offers us we are going to put for example that I am going to put insert let's go to the next right click look first at the in the text then at the icon change icon graphic and this is going to be called interesting to know what it offers us clients we are going to put this insert look that's it this is already working eye but but but but what we are going to do is we are going to copy we are going to copy all the column we select the whole column we click on the a control c and we go to the B sales we copy control V we go to purchases control V we go to products control V we go to customers control V there we have it let's see let's see look Yes We are not going to sales, it has already changed, look, it is already changing, look here, look, look here, look here, if I give it, for example, a product, look, it is on the product sheet, how do we differentiate it with this red bar? Look, let's put it to see, let's send it a little higher we are going to send it back right click send to the back Ok look send to the back one click send to the back but let's go to the main page We already have it, it is this main one we are going to copy it control c we are going to go to sales control v and we are going to put it we are going to send it to the back look right click send to the back we are going to go shopping control V right click send to the back there we have it to see there it is products control v and products right click send to the back we go to customers control V right click send to the back where it is send to the back here we have it not there it is Look now if we go to sales sales purchases products customers look how it is already working in a very nice way no there we have it main we can delete this we are going to start padding without padding okay What happens look if we go to the right it disappears not if you don't want this column to disappear look click on the first cell to one and we go to view view tab and here on the right it says immobilize click and we could say the immobilize first column here look that way it will never disappear No matter how much in the horizontal bar they go to the right well that way the menu does not disappear look let's go to sales purchases products customers if you want it to look even more beautiful look here in view you can Disable grid line like this header that way it will already be seen look but you have to do it in all sheets purchases in all sheets disable all these two options grid lines and header remove the check look and now we already have it here we are not going to put for example look in main we are going to put to see to see to see something we are going to put here menu main menu to differentiate it we are going to go to sales sales we are going to put purchases here we are going to put products here we are going to put here customers well look main sales shopping products customers look there it is good go to sales right click twice click fill format and I could put this green let's go shopping look let's click here fill I'm going to put this little blue We are going to go to products, one click fills it, they make it purple, we are going to go here, customers , one click fills it, and they can put this green, for example, well, look, how will it change color if I give the product, purchases, sales, and the main thing, well, this is simply changing color and that's it OK, but the interactive menu is on the left hand side. Okay, that's it if you liked the video Comment let me know if you have any questions also write to us write to us in the comments I'm going to stay until here see you in the next one video [Music] [Music]
