Range(OldSelection(i).Addr).Formula = OldSelection(i).Val ' Make sure the correct workbook and sheet are active ' Works for Outlook and Chrome, but not Excel ' Works for Excel and Outlook, but not ChromeĪpplication.OnUndo "Undo the macro", "UndoMacro" If TypeName(Selection) "Range" Then Exit Sub ' Set shortcut to Cntl+Shift+V, for example To paste both objects and text in Excel, with an option for undo, use ' Custom data type for undoing Then you can decide whether or not you want to stick w/your first choice (the shortcut will now invoke PasteTextOnly and no longer invoke xyz) or try to come up with another key combo. If the key combo is in use, underneath the "current keys" box, it tells you "Currently assigned to: xyz", where xyz is the command that already uses this shortcut. To bind the shortcut to the command (make it remember / save the new shortcut), click the "Assign" button.Click in the "Press new shortcut key" textbox, then press the key combination that you want to use to do this command.File > Options > Customize Ribbon > then click "Customize." button at bottom left labeled with "Keyboard shortcuts:".In Word 2007-2013 (maybe earlier, don't remember), you can bind the keyboard shortcut of your choice to commands.
![excel mac shortcut paste without formatting excel mac shortcut paste without formatting](https://www.exceltip.com/wp-content/uploads/2020/01/Capture-14.jpg)
The function already exists, it just doesn't have a shortcut out of the box, but you can give it one.