— iIT-Services


I recently tried to have the custom date format in MS Excel

DDD DD.M., as of Mon 24.5. formatted on two lines in a single cell. That is, as:


Aesthetisc of MS Office required me to implement this through formatting, instead of, e.g., using two cells with different formulas.

The solution was to use special characters, i.e., the line break character. Here, we’re talking about “ALT Keyboard Sequences”. Meaning: press and hold the ALT key while typing a sequence of numbers. For a line break, the sequence is “0010” or just “10”.

For the challenge above, in Excel, that meant typing DDD, then the ALT-sequence, and finally the DD.M. into the custom cell format. Interestingly enough, Excel makes a line break without showing the second (and further) line(s), but perfectly working as format.

The key sequences for any speical character can be found for example on https://tools.oratory.com/altcodes.html (EN) or also http://www.sonderzeichen.de/sonderzeichen_mit_alt.html (DE).

Read More

“Everything” is search engine that locates files and folders by filename instantly for Windows. Unlike Windows search “Everything” initially displays every file and folder on your computer (hence the name “Everything”). You type in a search filter to limit what files and folders are displayed: https://www.voidtools.com.

Thanks, T., for the hint.

Read More

In case, during your partition resizing, your Windows installation turns sour (e.g., when installing multi boot such as with Bootcamp on a Mac), the follwing tutorial might serve the purpose: https://www.digitalcitizen.life/command-prompt-fix-issues-your-boot-records.

Especially the Bootrec.exe does a good job in the case of a “Missing operating system”.

Read More

The following tutorial is borrowed from: https://superuser.com/questions/1270251/resizing-windows-10-bootcamp-partition-manually, generously written by the user dardeshna.

Read More

Process Explorer shows you information about which handles and DLLs processes have opened or loaded.

The Process Explorer display consists of two sub-windows. The top window always shows a list of the currently active processes, including the names of their owning accounts, whereas the information displayed in the bottom window depends on the mode that Process Explorer is in: if it is in handle mode you’ll see the handles that the process selected in the top window has opened; if Process Explorer is in DLL mode you’ll see the DLLs and memory-mapped files that the process has loaded. Process Explorer also has a powerful search capability that will quickly show you which processes have particular handles opened or DLLs loaded.

The unique capabilities of Process Explorer make it useful for tracking down DLL-version problems or handle leaks, and provide insight into the way Windows and applications work: https://docs.microsoft.com/en-us/sysinternals/downloads/process-explorer.

How to use it is also described, e.g., under
https://www.techsupportalert.com/content/how-find-out-which-windows-process-using-file.htm or

Read More

A small application to simplify the process of creating symbolic and hard links in Windows 7 and Windows 8 (likely Vista too). It is a GUI for the MKLINK command in Windows, which makes creating the links much easier.

The program requires administrator permissions due to use of the command prompt, so you should run it as an administrator if you experience any problems.

Note: It is not possible to create a hard link from a network share. You must use a symbolic link instead: https://sourceforge.net/projects/symlink-creator/.

Read More

A secure solution for file and email encryption. Gpg4win (GNU Privacy Guard for Windows) is Free Software and assists in sending emails via Outlook etc. using PGP: gpg4win.de.

Read More