Windows general

Sysinternals

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

psexec \otherComputer cmd

Command redirection

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

dir file.txt > output.txt 2>&1

Raise your Profile Quota

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

HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesSystem

Remote Shutdown of other computers

(requires appropriate permissions)

shutdown -i

Start programs without taskbar

STRG ALT ENTF -< Applications, File -< New Task (Run) ...

Windows Autostart Programs

See all Autostart programs in Windows

msconfig

Get information about the running Windows System

# wmic os get osarchitecture
OSArchitecture
32-bit

# wmic os get Version
Version
6.1.7601

# wmic os get Caption
Caption
Microsoft Windows 7 Enterprise

# wmic os get
(everything)

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

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlKeyboard Layout]

"Scancode Map"=hex:00,00,00,00,00,00,00,00,02,00,00,00,2a,00,3a,00,00,00,00,00

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

Disable Alt Shift Shortcut to changes Languages

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)

shutdown -i

Kill a program on another computer

taskkill.exe /S OTHER_COMPUTER_NAME /U OTHER_COMPUTER_YOUR_USERNAME /P OTHER_COMPUTER_YOUR_PASSWORD /IM foobar.exe

Robocopy

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

Example to automatically copy drive C to share m:

net use m: \computer14backup
robocopy c: m: /r:0 /w:0 /e

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

wuauclt /ShowSettingsDialog
wuauclt /ShowWU

Windows Update erzwingen

net stop wuauserv
Reg Delete "HKLMSoftwareMicrosoftWindowsCurrentVersionWindowsUpdateAuto Update" /v NextDetectionTime /f
net start wuauserv
wuauclt /detectnow

Sync Windows System Time With Timeserver

net time \zeitserver /set /YES

DNS Cache

Clear the DNS cache

ipconfig /flushdns

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.

=VLOOKUP(B7; OtherSheet!$A$1:$A$65000; 1; TRUE)
=NOT(ISNA(VLOOKUP(B7; OtherSheet!$A$1:$A$65000; 1; FALSE)))

Copy Format

Format Painter

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

=COUNTIFS(A2:C38; {"#N/A"})