The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

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

    Join 4,262 other subscribers

Archive for February, 2023

Wireshark Cheat Sheet – Commands, Captures, Filters, Shortcuts

Posted by jpluimers on 2023/02/28

[Wayback/Archive] Wireshark Cheat Sheet – Commands, Captures, Filters, Shortcuts

It is available both a huge [Wayback/Archive] jpg (2500×2096 pixels), so it already prints well on A5 or A4 sized paper for reference and as a [Wayback/Archive] PDF (so you can print it on even larger paper sizes).

Via: [Archive] Murdock (@Generic42) / Twitter in a DM.

–jeroen

Read the rest of this entry »

Posted in *nix, *nix-tools, Communications Development, Development, Hardware, Network-and-equipment, Power User, Software Development, Wireshark | Leave a Comment »

Some Bitly Support links

Posted by jpluimers on 2023/02/27

Knowing part of URL shortening by browsing through shortened URLs and creating auto-generated ones, I was new to create custom shortened URLs.

So here are some links about using bit.ly:

–jeroen

Posted in About, LifeHacker, Personal, Power User, WWW - the World Wide Web of information | Leave a Comment »

Bindende uitspraak Kifid: kosten nieuwe hypotheekakte bij eeuwige erfpacht voortaan voor bank

Posted by jpluimers on 2023/02/24

Voor mijn link-archief: [Wayback/Archive] Bindende uitspraak Kifid: kosten nieuwe hypotheekakte bij eeuwige erfpacht voortaan voor bank

–jeroen

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)

  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:
    • CommandV: Paste
  • When I want to decide which properties to copy:
    • CtrlCommandV: Paste Special
  • When I want just text:
    • CtrlU, CommandV: Edit cell, Paste

On MacOS, CtrlU is the equivalent of F2 on Windows (similarly, CommandT 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 CtrlU / 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

Posted in Excel, Office, Power User | Leave a Comment »

geerlingguy/my-backup-plan: How I back up all my data.

Posted by jpluimers on 2023/02/23

Long read worth your time: [Wayback/Archive] geerlingguy/my-backup-plan: How I back up all my data.

Video titled [Archive] Backups: You’re doing ’em wrong! – YouTube below the signature.

Via: [Archive] Chris Bensen on Twitter: “Just watched the latest @geerlingguy video on backups (…). Watch it! My personal backups have gone through some changes and it’s currently horrible so I’m going to implement the 1-2-3 backup plan in the new year. Thanks Jeff!” / Twitter

–jeroen

Read the rest of this entry »

Posted in Backup, Power User | 1 Comment »