This video describes how to create a custom toolbar in excel. First we have to go to tools menu in the excel. Next take the option of customize there and then choose the toolbars there. Next there will be the option “new” tab in that box. You have to select it first and then give a name the toolbar, which you are going to create. Then will be get the tool bar. Next if you want to add the buttons to the toolbar that you have created now, you have to go to commands tab. Then you will get categories and commands tabs again. Next choose any menu from the category tab and then you will get commands in the commands tab. So you can drag the commands from there to your toolbar directly. Next if you want to create a macro on your toolbar, you have to go to macros in the category and then choose the custom macro button in the commands. Then simply drag it to your custom toolbar. If you want to change and incorporate the macro you just right click and choose assign macro there and choose the option and there and click ok. If you want to change the sign of any button on your toolbar you just simply give a right click and go the option of change button image and select any image that you want. You can now do the all functions that you want from your custom toolbar.
Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.
Other worthwhile deals to check out:
- 97% off The Ultimate 2021 White Hat Hacker Certification Bundle
- 98% off The 2021 Accounting Mastery Bootcamp Bundle
- 99% off The 2021 All-in-One Data Scientist Mega Bundle
- 59% off XSplit VCam: Lifetime Subscription (Windows)
- 98% off The 2021 Premium Learn To Code Certification Bundle
- 62% off MindMaster Mind Mapping Software: Perpetual License
- 41% off NetSpot Home Wi-Fi Analyzer: Lifetime Upgrades
Be the First to Comment
Share Your Thoughts