Since it is a day-to-day task, we have a lot of other options available under pasting content in Excel from one cell/sheet to another and for that sake, we have different shortcuts associated with all these options. I don’t think we would have anyone in the crowd that doesn’t know Ctrl + C and Ctrl + V shortcut in Excel which allows us to copy and paste the values in different cells, different sheets, etc. Since it is one of the most performed activities within the tool, it has a variety of shortcuts to get work done as well as to save time. I am sure you all will be agree with the statement. The most common task that I ever perform in Excel is Copy and Paste. That should be all you need to do.Introduction to Excel Shortcut Paste Values
![what keyboard shortcut for paste what keyboard shortcut for paste](https://cybertext.files.wordpress.com/2016/08/paste_text_only.png)
![what keyboard shortcut for paste what keyboard shortcut for paste](https://i.pinimg.com/originals/ba/8a/67/ba8a6722cff858ecc2a44e6a03f2e760.jpg)
Select the template to save this change to (Normal.dot is the default), then click Assign. To assign Alt+Shift+V instead, click in the Press New Shortcut Key field and press that new key combination. The Current Keys box says that Ctrl+Shift+V is assigned to it.ĥ. Select PasteFormat from the Commands list (you can only see it after you’ve selected Edit in the Categories list). To assign Alt+Shift+V to PasteFormat (and therefore unassign the default Ctrl+Shift+V), do this:Ĥ. Repeat steps 1 to 5 but this time press the Alt+Shift+V combination at step 3. Under the Press New Shortcut Key field, it says that it’s currently assigned to PasteFormat.Ħ. In the Press New Shortcut Key field, press the key combination (e.g.
![what keyboard shortcut for paste what keyboard shortcut for paste](https://i.pinimg.com/originals/f0/e9/5e/f0e95e0ea6698f8fb011546a41618e5e.jpg)
In Word 2003, you can see what command a key combination is assigned to by opening a new blank document (based on normal.dot) and doing this:ģ. Close the Microsoft Visual Basic window.Paste the Selection.PasteSpecial DataType:=wdPasteText line from the macro above AFTER the last ‘ and BEFORE the End Sub line.Select Normal.dot (or whatever template you want to add this macro to) from the Macros in drop-down list.In the Macro name field, type NoFormatPaste.Go to Tools > Macro > Macros ( Word 2003)OR Developer tab > Macros ( Word 2007).To add the NoPasteFormat macro to your Word template: Selection.PasteSpecial DataType:=wdPasteTextĮnd Sub Add the macro to the Word template Then, when you need to paste in a lot of text as unformatted text, you just press the keyboard combination and it’s done. Normal.dot) and apply a keyboard command for it. Select Edit > Paste > Paste Special > Unformatted Text from the menu ( Word 2003) OR Home tab > Paste > Paste Special > Unformatted Text ( Word 2007).īut what if you have LOTS of text to paste in as unformatted text? Well, you can set up a macro in your template (e.g.
![what keyboard shortcut for paste what keyboard shortcut for paste](https://chrismenardtraining.com/_CMT/images/sections/posts/2019/09/QAT_Chris_Menard_.jpg)
You have to do this immediately after pasting - as soon as you move away and do something else with the document, the icon option is gone. Paste the text and click the little icon at the bottom right of the pasted text, then select Keep Text only.Some of the standard methods within Word 20 are: Word has several ways you can achieve this, some more convoluted than others, but as far as I know, there’s no standard keyboard command to paste text in as unformatted text. And sometimes you don’t want to keep any of the styles in the original text - you just want to paste in the text without any formatting. Text can take on the styles of the destination document/template or keep its own styles. Copying text from one Word document to another can be problematic, especially if you’re using templates and styles.