Create a custom command, assign it an icon, and included it in the Quick Access Toolbar in Excel


How do you create a custom command, assign it an icon, and include it in the Quick Access Toolbar (QAT) in Excel (2010)?

As an example, [Ribbon > View > Show (section)] includes the option to show or hide (Row & Column) Headings.

I looked for that as an existing shortcut (to add to my QAT) by going to:

        File > Options > Quick Access Toolbar > All Commands

However, although I looked under [Headings], [Hide Headings], [Show Headings], and [Unhide Headings], I could not find it.

Can someone explain how to create a custom QAT shortcut for that function?

Who is Participating?
Rob HensonConnect With a Mentor Finance AnalystCommented:
The above comments show the process for using an existing Command. For a Custom Command as suggested in the question you would first have to write the macro for that command. You can then use the above process for choosing the macro and assigning an icon.

There are limitations with Custom Commands using macros. For example, if you want the Custom Command to be available for all workbooks, the macro will have to be in your Personal macro workbook (Personal.xlsb). Those macros then have to be written in such a way that they are universal, eg not reliant on specific worksheets within a workbook.

In the above process, at the bottom of the right hand pane you will notice a Modify button. This is greyed out when using standard commands but will become available if you are choosing a macro driven command. The modification then allows the choice of an icon, albeit somewhat limited.
JohnBusiness Consultant (Owner)Commented:
You were close.  

Excel 2016, Quick Access, Customize, All commands and select Hide & Unhide. Add to the Quick Access Toolbar and it is a pull down for all Hide and Unhide. I tested that here and it works as advertised.
Wayne Taylor (webtubbs)Commented:
Hide & Unhide hides the selected rows or columns.

What you are after is called "View Headings". The easy way to find it is to select "View Tab" from the "Choose commands from" list.
WeThotUWasAToadAuthor Commented:
Thanks Rob.
Rob HensonFinance AnalystCommented:
Glad to be of help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.