The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 4,180 other subscribers
«
»

Excel for MacOS seems to have no post-paste shortcut to modify the paste options

Posted by jpluimers on 2023/02/24

Excel on Windows has a neat trick where you can press the Ctrl key after a paste operation.

This lets you determine after pasting if you want to change the [Wayback/Archive] Paste options in a similar way “Paste Special” will modify this while pasting as shown for instance at [Archive] What is the Excel keyboard shortcut for ‘paste special’? – Quora (excluded from the WayBack machine)

  1. Copy your source (Ctrl + C)
  2. Press Ctrl + V – Pastes as usual
  3. Press Ctrl – Paste options get displayed
  4. Press ‘P’ for paste special /‘V’ for values/’F’ for formulas etc

and [Wayback/Archive] Shortcut in Word or Excel for Special Paste?

Word 2013:

After having copied something go where you want to paste it (without pasting the format). CTRL+V (it will temporarily paste the format too) then CTRL (push and release the control key) then T (the last T means “keep text only”).

Excel 2013:

After having copied something go where you want to paste it (without pasting the format). CTRL+V (it will temporarily paste the format too) then CTRL (push and release the control key) then V (the last V means “paste Values”).
It’s important that the second CTRL key is released before typing the last letter.
This method requires just 4 keyboard hits, no macros and no use of the mouse in a dialog window.

The cool thing about this feature is that you can visually see the original paste, then determine how you want to modify it.

On MacOS, there is the post-paste glyph you can click, but no keyboard shortcut.

Basically, here are three ways I now work on MacOS while pasting:

  • When I really want to paste all properties on the ckipboard:
    • Command–V: Paste
  • When I want to decide which properties to copy:
    • Ctrl–Command–V: Paste Special
  • When I want just text:
    • Ctrl–U, Command–V: Edit cell, Paste

On MacOS, Ctrl–U is the equivalent of F2 on Windows (similarly, Command–T is the equivalent of F4) and brings the cell into edit mode before pasting. The mouse-equivalent is double clicking the cell before pasting.

I got that Ctrl–U / F2 trick from [Wayback/Archive] Always Match Destination Formatting | PCMag via [Wayback/Archive] Excel copy-paste: always match destination formatting – Super User.

Related

All based on [Wayback/Archive] macos excel “paste options” shortcut – Google Search

–jeroen

This entry was posted on 2023/02/24 at 12:00 and is filed under Excel, Office, Power User. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

«
»
 
%d bloggers like this: