Thorsten Gunkel

Windows general

Sysinternals

Sysinternals, a tool collection for Windows. Especially the Process Explorer, choose show lower panen and then dll.

Command redirection

Even with Windows you can redirect the output and input of your shell commands.

Raise your Profile Quota

Every user may raise the quota for his user profile (as long as your privileges permit this)

Remote Shutdown of other computers

(requires appropriate permissions)

Start programs without taskbar

Windows Autostart Programs

See all Autostart programs in Windows

Get information about the running Windows System

What annoys you in Windows

Deactivate caps lock key

You'll rarely need it, it annoys you often. This will make it work like the normal Shift key. See also How to Disable Caps Lock Key in Windows 7, 8, or Vista

Disable Alt Shift Shortcut to changes Languages

If you press Alt + Shift in Windows the default is to switch between German and English Keymap (at least in a German Windows). This is very annoying if you use for example Emacs where many Shortcuts include Alt + Shift. You can disable it like this

BIOS clock runs on UTC

Normally Windows changes the BIOS clock every time you change the timezone or for every daylight change. If you use more than one OS this is very annoying. Fix for this: WindowsLinuxDualBootTime.reg For a 64 Bit Windows you might need a QWORD instead

Windows Networking

Remote shutdown of another computer

(you need privileges for this)

Kill a program on another computer

Robocopy

RoboCopy, a tool to (automatically) copy files in Windows.

Example to automatically copy drive C to share m:

Enter CTRL ALT DEL in a remote desktop connection

In a remote desktop connection you can enter CTRL ALT DEL via CTRL ALT END.

Windows Update

Windows Update erzwingen

Sync Windows System Time With Timeserver

DNS Cache

Clear the DNS cache

MS-Office

Repeat a command in MS Office

Repeat a command in MS Office: CTRL y

Excel search a value in a range of cells

You have a range of data, (for example OtherSheet!$A$1:$A$65000) and you have a cell (for example B7) and you want to know if its content can be found in the range of data

If the last parameter is TRUE or not 0 than you will get non exact hits. Be careful.

Copy Format

Mark area with the desired format, select Format Painter icon, hold CTRL key, mark area which should also get the format.

How many Excel cells in this range are #N/A