[SC-CSTD] FW: [tech-vi Announce List] New Paste keyboard shortcut for Excel

[Frank Loza]

From: tech-vi at groups.io <tech-vi at groups.io> On Behalf Of David Goldfield
Sent: Monday, November 28, 2022 12:53 AM
To: List <tech-vi at groups.io>
Subject: [tech-vi Announce List] New Paste keyboard shortcut for Excel

 

Office Watch - Tuesday, November 1, 2022 at 5:01 PM


New Paste keyboard shortcut for Excel


There’s a new paste keyboard shortcut coming to Excel that will be very handy when pasting into a cell, but perhaps also a little confusing.

A common Excel task is pasting content into a cell from non-Excel sources (a web page, document, email etc).  Doing that now is quite possible though a little clumsy, choose from:

*	Paste pressing Ctrl+V, and then look at the Paste Options mini-toolbar to select Paste Values or Match Destination Formatting 

  <https://office-watch.com/fredagg/uploads/2022/11/image.png> 

*	Go to Home | Paste (or Alt, H, V ) and choose Paste Values or Match Destination from the drop-down menu.
*	Also at Home | Paste, down the bottom of the drop-down menu is Paste Special, choose Values or Text.  Ctrl+Alt+V is the shortcut to Paste Special.

  <https://office-watch.com/fredagg/uploads/2022/11/image-1.png> 


Ctrl + Shift + V – Paste Values or Match Destination Formatting


New in Excel for Windows (and Excel for Mac soon) is Ctrl + Shift + V which will automatically paste in either:

*	Values OR
*	Match Destination Formatting

Depending on what’s being pasted in.

<img decoding="async" width="690" height="501" data-tf-not-load src="https://office-watch.com/fredagg/uploads/2022/11/Excel-PasteValues-opt-resized.gif" alt class="wp-image-56079">Source: Microsoft


A little confusion


The Ctrl + Shift + V shortcut probably made sense to Microsoft, thinking within the context of Excel alone.

But Ctrl + Shift + V means Paste Text Only in Windows and Mac (Cmd + Shift + V) and in Word/Outlook.

Giving that shortcut a different meaning in Excel could confuse people,


Who gets it?


The Ctrl + Shift + V shortcut for Excel 365 will first appear for Insider/Beta Channel users with Excel 365 for Windows v2210 build 15726.20000 or later.

Microsoft promises it’s “coming soon” to Excel for Mac.

Text to Excel Date conversion by adding Zero with Paste Special <https://office-watch.com/2022/text-to-excel-date-conversion-paste-special/> 
Excel Paste Special with math operations <https://office-watch.com/2022/excel-paste-special-math-operations/> 
Paste tricks and tips for Microsoft Word <https://office-watch.com/2020/paste-in-microsoft-word/> 
Inside Smart Copy and Paste in Word <https://office-watch.com/2022/word-smart-copy-and-paste/> 

https://office-watch.com/2022/excel-new-paste-keyboard-shortcut/

 

     David Goldfield 

Assistive Technology Specialist

 

Feel free to visit my Web site

WWW.DavidGoldfield.info <http://WWW.DavidGoldfield.info> 

_._,_._,_

  _____  

Groups.io Links:

You receive all messages sent to this group. 

View/Reply Online (#3054) <https://groups.io/g/tech-vi/message/3054>  | Reply To Group <mailto:tech-vi at groups.io?subject=Re:%20%5Btech-vi%20Announce%20List%5D%20New%20Paste%20keyboard%20shortcut%20for%20Excel>  | Reply To Sender <mailto:david.goldfield at outlook.com?subject=Private:%20Re:%20%5Btech-vi%20Announce%20List%5D%20New%20Paste%20keyboard%20shortcut%20for%20Excel>  | Mute This Topic <https://groups.io/mt/95305057/318502>  | New Topic <https://groups.io/g/tech-vi/post> 
Your Subscription <https://groups.io/g/tech-vi/editsub/318502>  | Contact Group Owner <mailto:tech-vi+owner at groups.io>  | Unsubscribe <https://groups.io/g/tech-vi/leave/11845740/318502/1820159643/xyzzy>  [floza58 at bellsouth.net]

_._,_._,_

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nfbnet.org/pipermail/sc-cstd_nfbnet.org/attachments/20221128/e7006b96/attachment.html>