In Excel for Mac the F4 key is assigned to the Paste command, which is driving me crazy so I decided to do something about it.

For instance the above procedure was done in Excel 2011, but my Excel 2008 version of Excel for Mac wasnt affected and has to be done separately.

Excel Icon How To Assign F4

The Command Y function is not quite the same as redo (which the above process outlines how to assign F4 to Redo).

I often use the F4 key (Repeat Command) in the Windows version to quickly delete rows and columns.

The Command Y function (I believe Repeat Command) is not customizable cannot be assigned using the Tools Customize Keyboard.

I wrote a new post showing how to put the the Repeat command icon on the toolbar, which works even better.

A pain in the you-know-what, but whats a fella supposed to to.

YOU HAVE SAVED MY LIFE I am in the process of setting up some excel sheets for a client of mine that includes hundreds and hundreds of rows of information and changing this has saved me loads of time adding in hundreds of new information Thank you again so much.

Or use the Switch Reference on the Formulas tab of the Ribbon.

This could be an image that you have created, or one that you downloaded from a website.

By using our own icons we can create customised workbooks and not be constrained by the standard Microsoft icon set provided.

In this example I have a macro that exports all the worksheets of a workbook to PDF, and I want to assign it to the icon shown below.

This icon was downloaded from flaticon.com, a fantastic resource for icons that you can use for your macros.

Excel Icon Free To Download

This is free to download and if you do not have it already you can download it here Custom UI Editor for Office.

You may see some XML code appear as soon as you open the file, but you will probably need to insert some sample XML code to get started.

You can do this by clicking Insert, Sample XML and then Custom Tab.

Change the label for the tab, group and then button to what you want to use.

Then enter the name of the image you want to use for the image argument.

Finally enter the name of your macro for the onAction argument.

You can copy and paste the relevant lines of code to easily add more buttons, groups or tabs.

Browse and select your icon and it will be added to the file.

Click the sign next to the workbook name to expand the list of all added icons.

Your example showed how to add a custom ribbon to a workbook.

Could I also create an add-in and use the Custom UI editor to add my own icons Would I create a new ribbon for PERSONAL.XLSB.

I have not tried creating one in the PERSONAL.XLSB before but cannot see why this would not work also.

If I add a ribbon to a workbook, if I then copy the workbook, would the ribbon also be copied.

If this is the case, then in certain situations, would this negate the need for a separate add-in.

An add-in would remain a far more efficient way of distributing macros, or in this case a Ribbon tab though.

I currently have quite a few macros that I have displaying on a custom tab in the ribbon but the standard microsoft icon images dont match the macro functions well at all How would I go about achieving this.

Excel For Mac Icon