Word for Mac 2011 Paste Special/Keep Txt Only Once again thank you all and I am glad my macro is useful. Chris1969 plain text unfortunately doesn't support footnote markers (or any type of field) so if you paste unformatted, the footnote marker gets pasted as a space. You could click the Keep Text Only icon (on the far right) but if you want to adjust your defaults, select Set Default Paste to open the Office application's options: Set the defaults you want (I chose Keep Text Only for all) and click OK.
I hardly ever want to paste with formatting when copying into Word 2016 or Excel 2016 (seriously, who wants fonts when copying into a spreadsheet?). Is there a way to set the default paste to paste text only when I hit Cmd+V?
5 Answers
In a roundabout fashion yes, mostly..
In MS Office their version of 'Paste as plain text' is called 'Paste and Match Style and uses the macOS system defaults (
OptionCommandShiftV
) for paste as plain text for that function.
Now if you don't want to have to do that four finger salute just to paste (essentially) plain text, you can change the menu shortcuts in any application via the Keyboard Preference pane.
- Click on System Preferences > Keyboard > Shortcuts > App Shortcuts
- Click the + button and from the Application menu select (for example) Microsoft Word.
- Enter the menu title that you want to change. noting that the menu that you want to assign or reassign it's keyboard shortcut much match exactly what the menu says down to the capitalization.
- Click in the Keyboard Shortcut field and tap the keyboard shortcut you want to assign to that menu option, then click Add
- Repeat for any other keyboard shortcuts you want to add/change in any other applications you want to change them for.
In this example I reassigned 'Paste' to
OptionCommandShiftV
. And 'Paste and match Formatting' to
CommandV
.
Text messages for iphone on mac. I didn't do this for all applications as I don't want to chance messing up the behavior of other applications that you can copy/paste with.
How To Keep Text Only On Microsoft
NOTE that this is not really 'paste plain text' but will give you at least some of that functionality with very little pain.
To really get paste plain text in an MS Office application you would likely need something that could capture a regular paste command and then select the plain text icon from the formatting menu that pops up at the insertion point after you paste. There may be a macro program out there that can do that but I am unaware of any specific ones with that functionality.
Steve ChambersSteve Chambers
Steve Chambers solution works for Word, but not for Excel, because there simply is no 'Paste and Match Formatting' command in Excel. Only Paste or Paste Special. Thus for Excel, I believe the answer is no, unfortunately. But I'd love to proven otherwise.
Here is the definite solution for all versions:
- Select a cell and copy it.
- Go to Tools > Macros > record new macro.
- Specify a shortcut, for example option+command+b
- Click enter
- focus on any empty cell and click control+v, then select 'paste and style formatting' in the options.
- Go to Tools > Macros > Stop Macro.
- Next, download and install BetterTouchTool.
- Go to Preferences > keyboard.
- Add new shortcut. Enter command+v in the shortcut field and enter option+command+b in the triggered shortcut field.
- Done.
Monomeeth♦
I used the above answer as a reference and added my own solution:
Macro1: Copy some formatted text.
Let the document cursor stay somewhere in the document.
Go to Tools > Macros > record new macro.
Specify a shortcut with option+command+shift+b (finish macro creation)
Press cmd+v
Select destination formatting
Go to Tools > Macros > Stop Macro.
Default To Keep Text Only Paste Word For Macro
Macro2:
Go to Tools > Macros > record new macro
Specify a shortcut with cmd+v (override the normal paste)
This time you press option+command+shift+b
Go to Tools > Macros > Stop Macro
Done.
Now each time you press cmd+v you will call a macro which calls another macro and your text will be formatted correctly. (This is a solution tested in word)
For some versions of Word, I have v16.16.7 (whatever edition that is), I was able to use a version of the Tools > Customize Keyboard solution. Once there, select Edit on the left and PasteTextOnly on the right. Then, add whatever keyboard shortcut you want, e.g., command+V. I have not extensively road tested this but it seems to work. No idea if this can be extended elsewhere in Office.
How to search for rich text on mac. TextEdit offers powerful rich text formatting options. But sometimes it’s best to use TextEdit Plain Text Mode, which eliminates all formatting and, you guessed it, produces only plain text.
You must log in to answer this question.
Not the answer you're looking for? Browse other questions tagged ms-office .