There are two ways to paste specific cell contents or attributes like a formula, format, or comment copied from another cell. You can either pick a specific paste option directly from the Paste menu or click Paste Special, and pick an option from the Paste Special box.
Word Default Paste Text Only
WindowsWeb
In Line with Text keeps the image right where you insert it, next to the text. Square wraps text around the border of an image. Tight wraps text tightly around the image.
Paste menu options
Click Home > Paste and pick the specific paste option you want. For example, to paste only formatting from the copied cell, click Formatting . This table shows the options available in the Paste menu:
Keep Text Only Paste OptionPaste Special options
To use options from the Paste Special box, click Home > Paste > Paste Special.
Keyboard Shortcut: Press Ctrl+Alt+V.
In the Paste Special box, pick the attribute you want to paste.
Note: Depending on the type of data you copied and the Paste option you picked, some other options might be grayed out.
Common Paste and Paste Special options
You can use some of the paste special options from either the Paste menu or the Paste Special box. The option names might vary a bit but they results are the same:
For more about copying an entire worksheet to another location in the same workbook or to a different workbook, see Move or copy worksheets or worksheet data.
When you’ve copied data in Excel for the web, you have the following ways to paste it:
Tip: If you aren’t able to copy or paste, click Edit Workbook > Edit in Excel Online.
To paste copied cell contents, click the cell you want to paste into, and on the Home tab, click the Paste icon > Paste.
Here's what you can paste:
Mac For Word Default Paste Text Only Shortcut
Tip: You can also paste by right-clicking the cell you want to paste into and picking Paste.
Paste formulas
You can paste formulas (formulas with their values, or, values only) within a workbook or across workbooks in Excel for the web. For more information, see Copy and paste a formula to another cell or worksheet.
Paste values
When you‘ve copied data from calculated cells, and want to only paste the values without the formulas, click the cell where you want to paste the values, and then click Paste > Paste values.
You can paste values within a workbook or across workbooks in Excel for the web.
Paste formatting
Sometimes you want to reuse formatting in cells containing other data. For example, in the following image, the formatting from cells in the Store A column is pasted into the Store B column.
You can paste formatted data within a workbook or across workbooks in Excel for the web.
Here’s how you can paste only the formatting:
Paste Transpose
You can paste data as transposed data within your workbook. Transpose reorients the content of copied cells when pasting. Data in rows is pasted into columns and vice versa.
Here's how you can paste transpose cell content:
Need more help?You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice. See Also
Active1 month ago
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?
JeffJeff
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.
In this example I reassigned 'Paste' to OptionCommandShiftV. And 'Paste and match Formatting' to CommandV.
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.
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
16.5k22 gold badges2020 silver badges4343 bronze badges
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.
Jonathan PotterJonathan Potter
Here is the definite solution for all versions:
51k88 gold badges106106 silver badges154154 bronze badges
Duygu Mengioğlu NeşeliDuygu Mengioğlu Neşeli
Paste As Text Only
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.
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. Word Paste Text Only Shortcut
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)
rufreakderufreakde
![]()
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.
jbjojbjo
You must log in to answer this question.Not the answer you're looking for? Browse other questions tagged ms-office .Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |