Voor mijn link-archief: [Wayback/Archive] Bindende uitspraak Kifid: kosten nieuwe hypotheekakte bij eeuwige erfpacht voortaan voor bank
–jeroen
Archive for February 24th, 2023
Bindende uitspraak Kifid: kosten nieuwe hypotheekakte bij eeuwige erfpacht voortaan voor bank
Posted by jpluimers on 2023/02/24
Posted in About, LifeHacker, Personal, Power User | Leave a Comment »
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)
- Copy your source (Ctrl + C)
- Press Ctrl + V – Pastes as usual
- Press Ctrl – Paste options get displayed
- 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
- [Wayback/Archive] 5 Excel Paste Special Shortcuts That Will Save You Tons of Time
- [Wayback/Archive] Copy and paste specific cell contents
- [Wayback/Archive] Is there a way to make paste as text only the default action in Office 2016? – Ask Different
All based on [Wayback/Archive] macos excel “paste options” shortcut – Google Search
–jeroen
Share this:
Posted in Excel, Office, Power User | Leave a Comment »
The Wiert Corner - irregular stream of stuff 