1. Excel

• 1.1. Encryption

2. Internet Explorer

• 2.1. Shortcuts

3. Textpad

• 3.1. Shortcuts

4. Windows

• 4.1. A lot of not documented tricks

• 4.2. Add 'Cmd here' to Windows Explorer pop down menu

• 4.3. Search all files kind in Windows XP

• 4.4. Setting the PATH in Windows 2000 / Windows XP

• 4.5. Shortcuts

• 4.6. System log

• 4.7. Tab key to complete names in DOS

5. Word

• 5.1. Disabling some boring autocorrections

1.1. Encryption

  Tools -> Options -> Security

  File encryption settings for this workbook:

  File sharing settings for this workbook:

2.1. Shortcuts

  CTRL + TAB: Jump to address bar and mark current address so that it is ready for a new entry

  CTRL + mouse scrollwhell: zoom

  CTRL + I  : open favourites

  CTRL + H  : open history and show last visited page

  CTRL + E  : start web search

  CTRL + F  : start find

  CTRL + O  : open address dialog

  F11       : activate/deactivate full screen

  SHIFT + Refresh button: clear cache and refresh

3.1. Shortcuts

  CTRL + F2 : set mark

  F2        : jump to next mark

4.1. A lot of not documented tricks

For other undocumented tricks, take a look at the following links:

http://www.ntfaq.com

http://www.windowsitpro.com

4.2. Add 'Cmd here' to Windows Explorer pop down menu

In order to quickly start a DOS window in the selected directory, put the following text

  REGEDIT4

  [HKEY_CLASSES_ROOT\Folder\shell\Cmd Here]

  @="Cmd Prompt Here"

  [HKEY_CLASSES_ROOT\Folder\shell\Cmd Here\command]

  @="cmd.exe /k pushd %L"

in a file called

  cmdhere.reg

and double click it.

4.3. Search all files kind in Windows XP

In Windows XP, Micro$oft has introduced a feature like their philosophy: only files with extensions recognised by Micro$oft it self are scanned.

If a file as an unknown extension, it is simply ignored.

To avoid this problem, put the following text

  Windows Registry Editor Version 5.00

  [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex]

  "FilterFilesWithUnknownExtensions"=dword:00000001

in a file called

  filter.reg

and double click it.

4.4. Setting the PATH in Windows 2000 / Windows XP

The path is now managed by Windows 2000 / Windows XP and not the autoexec.bat or autoexec.nt files.

To change the system environment variables, follow the below steps:

- from the desktop, right click My Computer and click properties.

- n the System Properties window, click on the Advanced tab.

- in the Advanced section, click the Environment Variables button.

- finally, in the Environment Variables window, highlight the path variable in the Systems Variable section and click edit. Add or modify the path lines with the paths you wish the computer to access. Each

       C:\Program Files;C:\Winnt;C:\Winnt\System32

Taken from http://www.computerhope.com/issues/ch000549.htm.

4.5. Shortcuts

  F2         : rename a file or directory name

  WINKEY + M : minimize all

  +          : show the first level of the tree

  -          : mask the first level of the tree

  *          : show the complete tree (e.g.: in explorer)

  CTRL + S   : when used in windows explorer opens the search dialog

  ALT + PRINTSCREEN: copy only the selected window in the buffer

4.6. System log

System logs can be viewed with the event viewer:

  C:\WINNT\system32\eventvwr.exe

4.7. Tab key to complete names in DOS

In DOS there is the possibility to complete partially written names just by pressing the TAB key. This functionality has been copied from the UNIX/Linux world and is not so powerfull as them, but is better as nothing.

  Start the registry editor (regedit.exe)

  Move to HKEY_CURRENT_USER\Software\Microsoft\Command Processor

  Double click on the value CompletionChar

  Make sure the base is Hexadecimal and then set the value to 9 and click OK

  Close the registry editor

  Start a new CMD.EXE session and the change will have taken effect

5.1. Disabling some boring autocorrections

  Tools -> AutoCorrect Options ...