Mar 23 2022 08:49 AM
I regularly use the following sequence:
Left Click a Cell / Paste Special / Paste Special (on flyout menu) / Values and Transpose buttons.
Is there a way to create a shortcut or tool bar item so once I click on the destination cell I just hit the shortcut or tool bat item?
I'm using Excel for Mac on a MacBook Pro running OS Monterey
Thanks,
Ken
Mar 23 2022 09:12 AM - edited Mar 23 2022 09:15 AM
SolutionHi @Ken_Kovak, yes! You can record it as a Macro and Excel will save it as VBA. You will record your macro by going to the View tab and selecting "Record Macro" on the far right-hand side. You will complete the steps you listed above and Excel will copy that down. Now, when you need to complete that task you can simply enter the shortcut you assign for it and voile.
For more information on how to record a macro, please see: https://support.microsoft.com/en-us/office/automate-tasks-with-the-macro-recorder-974ef220-f716-4e01...
Mar 23 2022 09:12 AM - edited Mar 23 2022 09:15 AM
SolutionHi @Ken_Kovak, yes! You can record it as a Macro and Excel will save it as VBA. You will record your macro by going to the View tab and selecting "Record Macro" on the far right-hand side. You will complete the steps you listed above and Excel will copy that down. Now, when you need to complete that task you can simply enter the shortcut you assign for it and voile.
For more information on how to record a macro, please see: https://support.microsoft.com/en-us/office/automate-tasks-with-the-macro-recorder-974ef220-f716-4e01...