r/excel • u/anil_2705 • Nov 25 '23
What's the best approach to easily paste as values? solved
Currently I'm using a macro to paste as values and assigned Ctrl+Shift+V to trigger it. But the downside is that I cannot undo anything once I use the macro. So any better approach to this problem? Or is there a way to enable undo after using a macro?
69
u/a_gallon_of_pcp 21 Nov 25 '23
Alt, e, s, v
8
u/anil_2705 Nov 25 '23
Solution verified
3
u/Clippy_Office_Asst Nov 25 '23
You have awarded 1 point to a_gallon_of_pcp
I am a bot - please contact the mods with any questions. | Keep me alive
3
u/anil_2705 Nov 25 '23
Cool. But looks like this is an older key combo. What would have been the ribbon selections for that?
9
u/jd-real Nov 25 '23
Yep, I use alt, e, s, v to paste values.
It used to be: e = Edit s = paste v = paste values from dropdown
14
u/anil_2705 Nov 25 '23
Someone commented the new one. Alt hvv
4
u/Henry_the_Butler Nov 25 '23
You'll also want Alt hvf for pasting functions.
1
u/Ender_Xenocide_88 1 Nov 26 '23
No love for hvn to paste links???
1
u/Henry_the_Butler Nov 26 '23
...we paste links in Excel?
2
u/Ender_Xenocide_88 1 Nov 26 '23
Not as in URL links... as in references to another range in your excel file. You can copy cell A1, then paste links into another cell on another sheet, and get the formula "='sheet1'!A1".
38
u/njpu 2 Nov 25 '23
Alt H V V
5
u/anil_2705 Nov 25 '23
Solution Verified
2
u/Clippy_Office_Asst Nov 25 '23
You have awarded 1 point to njpu
I am a bot - please contact the mods with any questions. | Keep me alive
2
u/LobbyDizzle 1 Nov 26 '23
I wish Mac's Excel didn't suck and used the cascading ribbon/hotkeys :(
3
u/odaiwai 3 Nov 26 '23
You can edit the Keyboards Shortcuts on the Mac (Go to settings, search for Keyboard Shortcuts, click Keyboard Shortcuts, look for App Shortcuts) and add your own shortcuts for all apps or for specific apps.
You need to match the text with the EXACT text in the menu (including ellipsis) for it to work. As you can see below, I have Paste Special as Shift-Cmd-V
1
1
32
u/sqylogin 730 Nov 25 '23
The latest versions of Excel 365 do in fact assign CTRL+Shift+V as paste values.
2
37
u/Vahju 67 Nov 25 '23
Add Paste as values to the Quick Access Toolbar.
If you add it as the first icon, you can use ALT+1 to activate.
I have mine setup as the third icon, so I use ALT+3.
Hope this helps.
8
u/wfp128 Nov 25 '23
I added this to the QAT quite a while ago. First with a macro and eventually with the built-in icon. I've never thought to take advantage of the QAT position / Alt+#. For me, your advice is very helpful and much appreciated!
6
u/awooten Nov 25 '23
yes, that would be my suggestion aswell. I have set ALT+1,2,3 to paste values, formulas and format and it works great
2
2
2
u/anil_2705 Nov 25 '23
Solution verified
1
u/Clippy_Office_Asst Nov 25 '23
You have awarded 1 point to Vahju
I am a bot - please contact the mods with any questions. | Keep me alive
2
u/BEaggie08 1 Nov 26 '23
Been doing it this way for years. For me, Alt+7=Paste Values and Alt+8=Paste Formulas.
1
1
18
u/gerblewisperer 5 Nov 25 '23
Ctrl+Alt+v, type v, hit enter
3
2
u/anil_2705 Nov 25 '23
Solution verified
1
u/Clippy_Office_Asst Nov 25 '23
You have awarded 1 point to gerblewisperer
I am a bot - please contact the mods with any questions. | Keep me alive
2
6
6
u/0entropy 4 Nov 25 '23
I use Ctrl + V, Ctrl, V.
2
u/anil_2705 Nov 25 '23
Solution verified
1
u/Clippy_Office_Asst Nov 25 '23
You have awarded 1 point to 0entropy
I am a bot - please contact the mods with any questions. | Keep me alive
3
u/Ginger_IT 6 Nov 25 '23
Alt H V V
And then spend a moment and see that the ALT tree can do (practically) every function.
And give the point(s) to whomever earned it. Because this IS solved.
2
u/anil_2705 Nov 25 '23
Solution verified
1
u/Clippy_Office_Asst Nov 25 '23
You have awarded 1 point to Ginger_IT
I am a bot - please contact the mods with any questions. | Keep me alive
1
u/anil_2705 Nov 25 '23
Yeah, just thought to give a bit of time just in case someone comes up with a better resolution, but Alt HVV it is.
2
u/Ginger_IT 6 Nov 25 '23
Let me know if you ever find that writing a macro is easier than a single ALT function. I have yet to find a reason... Unless I am stringing several together. But I just have them programmed into my 20 button mouse. (Logitech G600)
1
u/anil_2705 Nov 25 '23
Yeah, now i feel dumb to have used a macro when alt hvv does the job and can undo.
Overthought it instead of going simple I guess.
1
u/Ginger_IT 6 Nov 25 '23
Macros have a purpose. I've never found one yet. All of the work I ever get to do with Excel is minimal. Turning data into a table and sorting it is sorcery to those I work with.
But Excel is a learning process.
Now, go award the point(s) as described in the auto-mod message and close the issue.
1
u/anil_2705 Nov 25 '23
I do use macros for repetitive tasks. Why turn data into table to sort? Why not directly use filter and sort?
Yeah already marked it as solved and wrote the comment to the first two folks with ideal responses. Or do I write the comment for all correct ones? 😅
Newbie here.
3
u/chamullerousa 5 Nov 25 '23
I bought the Logitech G602 with programmable keys and then build macros into it for copy, paste, paste values, text to columns, and a couple others. Massive time saver! Highly recommended! Plus when people see you working you look like an absolute magician.
2
u/anil_2705 Nov 25 '23
I use the m720. Two vacant customisations left. Rest all are used. I guess scroll wheel click is the one I might use for this if I feel alt hvv not convenient. So far the shortcut seems fine.
1
u/timetotom 1 Nov 26 '23
This, OP. Assign buttons for Copy and Paste Values using X-Mouse. Absolute gamechanger.
4
u/prashantrajbhikshu 1 Nov 25 '23
Try powertoys
1
2
u/anil_2705 Nov 29 '23
Solution verified. Just used it. Does the work so simply. Loved it. Wish the shortcut was customisable per app though.
1
u/Clippy_Office_Asst Nov 29 '23
You have awarded 1 point to prashantrajbhikshu
I am a bot - please contact the mods with any questions. | Keep me alive
3
u/TheBigDickDon 2 Nov 25 '23
Alt + E + S and then V for values I think.
3
u/anil_2705 Nov 25 '23
Solution verified
1
u/Clippy_Office_Asst Nov 25 '23
You have awarded 1 point to TheBigDickDon
I am a bot - please contact the mods with any questions. | Keep me alive
3
u/Error83_NoUserName 1 Nov 25 '23 edited Nov 25 '23
Install PureText. A micro program to paste the text values. Map it to something like Ctrl+Shift+V (my combo too 🤣)
Buy a mouse (e.g. Logitech M590) with some function buttons. Map one to Ctrl+V, the other Ctrl+Shift+V
It works in every program. Outlook, OneNote, Excel, browser, ... And I can not stress this enough: This is sooooo convenient
1
u/anil_2705 Nov 26 '23
Gotta check if its available on my office laptop 😅
1
u/Error83_NoUserName 1 Nov 26 '23
Can't you ask a local administrator? I would install it if someone came asking 🤣. Just let them download it and do a check on virustotal. It's a free program.
1
u/anil_2705 Nov 26 '23
Yeah, gotta have a word with them...
1
u/Error83_NoUserName 1 Nov 26 '23 edited Nov 26 '23
I am one of them 🤣. Most of them blindly follow policies implemented by overpaid consultants and are unable to think outside of a box. And know only the policy as "the policy"
My viewpoint is simple: Is it clean software, does it allow free corporate use, does it increase your productivity, and is it not against an actual policy.
If it has all the checks, I'll install it. But most of the time when an admin refers to "the policy" they mean "I don't feel like giving support on unofficial software where the end user comes bothering me for all the time."
So they'll tend to keep end-user like monkeys. Dumb and inefficient within their sandboxed environment until they get a phishing mail and give away their username and password instead of actually educating people.
Sorry. Got a little off-topic in the end due to some corporate frustrations 🤣
1
u/anil_2705 Nov 26 '23
That phishing mail part tho 😂 Let's see what the tech team has to say about this power tools. Given that it's Microsoft's own thing, I'm guessing they should be okay with it...
1
u/anil_2705 Nov 29 '23
Just used power tools for this. Does the work so simply. Loved it. Wish the shortcut was customisable per app though.
2
u/austinburns 2 Nov 25 '23
if you have a right click button on your keyboard, you can hit that, then s, then v. works best for me.
1
u/anil_2705 Nov 25 '23
True, but my keyboard has a function key instead of right click unfortunately.
3
2
u/BobSacramanto Nov 25 '23
I added paste values to the quick access toolbar (or whatever is right below the ribbon) so I was able to program a mouse button to alt+2.
1
2
2
u/ZirePhiinix Nov 26 '23
You can assign Paste as Value to the Ribbon at the very top. Once there, Alt+(number) becomes the shortcut depending on its position.
If you press Alt once, you'll see those shortcuts labeled with their respective numeric shortcut.
1
u/anil_2705 Nov 26 '23
Either this qat or alt hvv, gotta try out both and see which one's more convenient.
2
2
u/fool1788 10 Nov 26 '23
Use the right click key ( the key with a box and 3 horizontal lines inside next to the right ctrl key) then + s + v
2
u/yazanwael Nov 26 '23
Yes you can, in this case, you'd have to create the "paste as value" shortcut in all of the office apps and with power toys map Ctrl+Shift+V to the quick access shortcut. The whole process is pretty easy and shouldn't take you more than 5 minutes
1
u/Myradmir 29 Nov 25 '23
Isn't ctrl+shift+a an existing shortcut to paste values?
1
u/anil_2705 Nov 25 '23
No. Nothing is happening with that. Gives me an error sound.
1
u/Myradmir 29 Nov 25 '23
Ah, joy. Maybe a 365 thing.
1
u/anil_2705 Nov 25 '23
yeah. excel latest update has ctrl shift v itself I suppose.
1
u/Myradmir 29 Nov 25 '23
And you don't have a menu with options after you do a normal paste?
1
u/anil_2705 Nov 25 '23
you mean press ctrl again and then v?
1
u/Myradmir 29 Nov 25 '23
In 365 it has a little helper pop up for the various options when you hover over them, the shortcut might exist under some other form in 2021 in which case it'll be on the menu after you press ctrl.
1
u/anil_2705 Nov 25 '23
I don't recollect seen such a menu in 2021
2
u/Myradmir 29 Nov 25 '23
Google says ctrl,alt,v then v is supposed to do it for 2021.
1
u/anil_2705 Nov 25 '23
Just tried. This worked... So far Alt e,s,v then hit enter or alt h,v,v are the alternatives. Have to see if anyone gets any better ones.
→ More replies (0)
0
u/Kuildeous 7 Nov 25 '23
There's a freeware I use called PureText. Very simple application that lets you paste as text anywhere with Windows+V (or whatever you want to assign it to).
If you're in a corporate environment, that might not be a viable option for you though. You may have to convince IT to verify it's safe before installing it for you.
1
1
u/Patroreddit Nov 25 '23
hi I am also using macro after using macro you can't undo it. so if you are using macro so check before using any sheet so that you terminate this problem.
1
1
u/Random_Hero-92 Nov 25 '23
Menue key + V does the trick, but many keyboards doesn't have the menue key
1
1
1
1
u/Q1ller Nov 26 '23
I usually like to paste values AND the formats. I think I'll just create a macro.
1
1
u/jdsmn21 4 Nov 26 '23
Tap the menu key (the mystery key on the right of the space bar) and tap v. Two key taps.
1
1
u/yazanwael Nov 26 '23
You can add it to quick access toolbar and it will automatically get assigned the shortcut Alt+(number between 1-9)
You can take that one step further by installing PowerToys and using the keyboard manager to map that shortcut (Alt+Number) to Ctrl+Shift+V The good thing about this approach is that you can have it also applied to all office applications
1
u/anil_2705 Nov 26 '23
So with power toys we can have per app customisation? Once been using autohotkey for some specific apps before to achieve that. 🥲
1
u/Status-Customer7178 Nov 26 '23
Select the area with the formulae. Right-click on the edge of the area and hold down the right mouse button. Now drag the area to where you want the values to be and release the button. A context window appears with the option "Copy here as values".
1
u/ExcelObstacleCourse 2 Nov 26 '23
I cover this in my first video titled “start here.” I use the right click button approach. When it isn’t available I sometimes use the right mouse actual button like a key. It is fluid when you get used to it.
https://youtube.com/@ExcelObstacleCourse?si=v7_7zC6dW1-KDLkH
1
u/david_horton1 14 Nov 26 '23
After copying select Windows Key+V to paste. In Windows Key+V mode you can pin the copy so that you can use it after you reboot the computer. In Windows Key+V mode you can paste anything you have copied in that session plus whatever you have previously pinned.
1
u/anil_2705 Nov 26 '23
clipboard content is retained if its pinned even after restart?
1
1
•
u/AutoModerator Nov 25 '23
/u/anil_2705 - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.