Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#370671 - 16/03/2018 15:56 Simple Excel question
JBjorgen
carpal tunnel

Registered: 19/01/2002
Posts: 3584
Loc: Columbus, OH
Just throwing this out there in case someone knows off the top of their head:

Is there a keystroke in Excel that will copy the computed value of a cell instead of the formula? I'm constantly copying between my spreadsheet and my online banking site, but when I copy and paste a value for a bank transfer, I get the stinkin' formula instead of the value.

is there a way to easily fix this behavior, or a keystroke modifier that will only copy the value?
_________________________
~ John

Top
#370672 - 16/03/2018 17:18 Re: Simple Excel question [Re: JBjorgen]
mtempsch
pooh-bah

Registered: 02/06/2000
Posts: 1996
Loc: Gothenburg, Sweden
Originally Posted By: JBjorgen
Just throwing this out there in case someone knows off the top of their head:

Is there a keystroke in Excel that will copy the computed value of a cell instead of the formula? I'm constantly copying between my spreadsheet and my online banking site, but when I copy and paste a value for a bank transfer, I get the stinkin' formula instead of the value.

is there a way to easily fix this behavior, or a keystroke modifier that will only copy the value?


Not sure for a permanent change, but Ctrl+Alt V, V, Enter
Ctrl+Alt V gives you the Paste special dialog
V picks Value (as opposed to formula)
Enter closes dialog
_________________________
/Michael

Top
#370673 - 16/03/2018 17:39 Re: Simple Excel question [Re: JBjorgen]
JBjorgen
carpal tunnel

Registered: 19/01/2002
Posts: 3584
Loc: Columbus, OH
Thanks Mike. That helps.

On my Mac, Ctrl+Cmd+V pops the paste special dialog, but then you have to use the touchpad to select Values and then Ok, which is still annoying. Apparently they didn't add the keyboard shortcut to that dialog on the Mac, at least in Office 2011. I just wish there was something even shorter, like Shift+Cmd+V or something like that.

And I made a mistake earlier...it's not when I copy to my web browser, it's when I copy between two different spreadsheets that I get the formula instead of the value.
_________________________
~ John

Top
#370674 - 16/03/2018 19:13 Re: Simple Excel question [Re: JBjorgen]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31597
Loc: Seattle, WA
Is Excel a requirement, or in your case could you use Numbers instead, since you're on a Mac? According to the web searches I'm seeing, in Numbers, Paste Values is swizzlestick-shift-V with no extra menus to answer (I haven't tried it though).
_________________________
Tony Fabris

Top
#370675 - 16/03/2018 19:21 Re: Simple Excel question [Re: JBjorgen]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31597
Loc: Seattle, WA
Not sure if any of these will work, I haven't tried it:

https://www.quora.com/Is-there-a-keyboard-shortcut-in-Excel-for-paste-values

Quote:

For the Mac, the Paste Values keboard shortcut is:
CTRL+CMD+V, CMD+V, ENTER

In Excel 2010 it's CTRL+Alt+V


Or...

Quote:

In Excel 2011 Mac, you have to create your own shortcut.

Go to tools>customize keyboard. select edit under categories, you'll find "paste values" on the right (a couple items under paste special). Just press a shortcut sequence (command+d for example) and add that as a new shortcut.

my life has improved so much since.
_________________________
Tony Fabris

Top
#370676 - 16/03/2018 19:24 Re: Simple Excel question [Re: tfabris]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31597
Loc: Seattle, WA
Also from the same page:

Quote:

For recent Mac (e.g. version 15) the prior answers do not work.
command-c to copy
control+command-+v or alt+command+v to raise special dialog
fn+v to select values
Enter
_________________________
Tony Fabris

Top
#370677 - 16/03/2018 21:33 Re: Simple Excel question [Re: JBjorgen]
JBjorgen
carpal tunnel

Registered: 19/01/2002
Posts: 3584
Loc: Columbus, OH
Quote:

In Excel 2011 Mac, you have to create your own shortcut.

Go to tools>customize keyboard. select edit under categories, you'll find "paste values" on the right (a couple items under paste special). Just press a shortcut sequence (command+d for example) and add that as a new shortcut.

my life has improved so much since.


This was the right answer! I remapped Shift+Cmd+V to Paste Values. Thanks so much Tony. Sometimes it's the little annoyances that can make the day so much more frustrating. I tip my hat to you sir!
_________________________
~ John

Top
#370678 - 16/03/2018 21:55 Re: Simple Excel question [Re: JBjorgen]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31597
Loc: Seattle, WA
Thanks! I just got lucky with google search terms. smile
_________________________
Tony Fabris

Top