Poke at it, pick it up, look at it, smell it, taste it, bang it against a rock. Select Values from the Paste option or press V on your keyboard. Press Ctrl + Alt + V on your keyboard to open up the Paste Special menu. Choose a new location in your workbook to paste the values into. Copy the data you want to paste as values into your clipboard. So far, with advanced excel, I've been pretty primitive in my approach when I run into an obstacle. To use the paste special keyboard shortcut. To paste the text, press and hold CTRL then V. The shortcut you can use to copy text in any editor is CTRL + C. Make sure you right click exactly where you want the pasted text to be. Yes, crude, but it works for me 95% of the time. To paste the copied text, right-click on any editor again and select Paste. I'm pretty stubborn and I didn't find a thread that answered this question of our's so I went to plan B. VB is not my friend (I'm still fighting with Excel) so I search the web and if that fails I experiment. I was looking for the same thing when I ran across this thread. Just the letter, no alt or anything extra. Is there a way to avoid having to use the mouse to access this list so that I can use 1) Ctrl+V to paste, then 2) a shortcut to open the dropdown, then ^3) Alt+whatever to select the option I want? The various options in the drop down list presented by this button have hotkeys (Alt + underlined letter) associated with them. Is there a keyboard shortcut to activate the paste options button that appears after a manual paste into a worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |