How to Print an Excel Spreadsheet to show the formulas within the cells

Q Is there any way to have Excel show or print the formulas rather than me having to move the cell pointer to check each formula in the formula bar?

A In Excel 2003 Hold down the CTRL key and press the button above the tab key.
This has 3 symbols on it but I dont know what they are.
It used to be the tilde key but this puts in dates on my version.

Free Font - London Underground or Tube

If you want a Freeware TTF that looks like London Underground download from here
http://www.fontstock.net/10483/london-tube.html
To install unzip it , right click, install
or
Extract the fonts to a folder on your drive.
Double-click on every font that you want to install
Click on “Install”:

Freeware Font London Underground or Tube

If you want a Font that Looks like the London Underground , The Tube

http://www.fontstock.net/10483/london-tube.html

London Underground Free Font

If you want a Freeware True Type Font that looks like the London Underground or Tube

http://www.fontstock.net/10483/london-tube.html

Install True Type fonts to Windows 7

Installing a Font – Method 1

To install a font, do the following:
1.Download a font

2.Make sure the font is unzipped
3.Right click on the font file and select install

Installing a Font – Method 2

To install a font through the font manager, do the following:
1.Download a font

2.Make sure the font is unzipped

3.Click the Start button, type font, and click on Fonts

4.Drag the font file into the Font manager




5.Your font is now installed

Enjoy your new fonts.

Select Next Variable Hot Key Fix

In Dragon Naturally Speaking you may get an error message relating to next variable hotkey is in use by another application and asking you to go to Tools Options Hotkeys and change it.
This is not possible you need to add a line to the options.ini file for each user you have set up.
Here is the procedure
Dragon NaturallySpeaking is attempting to register a hot key, but a separate application has already registered that same hot key.

Solution:

The Clear Variable Delimiters hot key is not configurable from the "Hot Keys" tab in the "Tools > Options" dialog. We recommend manually disabling the hot key(s) in the "options.ini" file. Each user profile will have a unique "options.ini" associated to that user.

To disable the "Select Next Variable Hot Key":


Exit from all open applications, including Dragon NaturallySpeaking 10.1.
Using Windows Explorer, browse to:
On Windows Vista: "C:\ProgramData\Nuance\NaturallySpeaking10\Users\[USER]\current"
On Windows XP: "C:\Documents and Settings\All Users\Application Data\Nuance\NaturallySpeaking10\Users\[USER]\current"
Right-click on the "options.ini" file and select "Open With", then select Notepad as the program to open the file.
Under the "[Options]" heading, enter "Select Next Variable Hot Key=0,0".
For example, the "options.ini" file should now display:
[Options]
Select Next Variable Hot Key=0,0


Click "File > Save" and then close the "options.ini" file.
Launch Dragon NaturallySpeaking 10.1.
Note: Other potential hot keys that can cause conflicts may include:


Select Next Variable Hot Key
Select Previous Variable Hot Key
Transfer Text Hot Key
If the error message being displayed is referencing one of these hot keys, follow the steps above to modify the "options.ini" file, but replace the text in Step 4 with corresponding hot key. For example:

[Options]
Select Next Variable Hot Key =0,0

How to Disable the CAPS LOCK

Understanding How Windows Key Re-Mapping Works
Windows doesn’t have a default setting to allow for disabling the key, so what we have to do is re-map the key to something non-existent so as to completely disable it. To do this manually, you’d open up regedit.exe and browse down to the following key:


HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layout



Here’s the format of the binary data in the Scancode Map key, with the important parts in bold and various colors:

00000000 00000000 02000000 00003A00 00000000

Here’s how it works:

•The first 16 zeros are just there to waste space.
•The “02″ in bold represents how many keys you are going to re-map plus 1. (It really represents the length of the data, but whatever)
•The orange bolded “0000″ is the key we actually want Windows to map TO, which in this case is nothing, or 0.
•The blue bolded “3A00″ is the key we are mapping from, in this case the caps lock key.
•The next 8 zeros are there to waste space as the null terminator.
You can map between multiple keys by incrementing the “02″ and then adding another of the colorful bold blocks in the middle. The 3A00 in the mix is the scan code. For example, if you wanted to disable the caps lock key and then change scroll lock into a caps lock key:

00000000 00000000 03000000 00003A00 3A004600 00000000

It might seem complicated, but it’s really fairly simple once you start working with it.

Downloadable Registry Hack to Disable or Remap the Caps Lock Key
Now that you’ve learned how these things work internally, you can download and extract the zipfile which contains the following files:

ChangeCapsToControl.reg Changes Caps Lock to be a Control key
ChangeCapsToShift.reg Changes Caps Lock to be a Shift key
SwitchCapsToScrollLock.reg Disables Caps Lock and swaps Scroll lock to be Caps Lock
KillCapsLock.reg Disables Caps Lock
DisableKeyboardRemap Uninstalls the preference by deleting the key

Once you’ve applied one of these registry files, you’ll have to reboot your computer for it to work. To uninstall, you can use the uninstall registry tweak, or you can simply delete the Scancode Map key entirely.

Download Keyboard Mappings Registry Tweaks
http://www.howtogeek.com/geekers/KeyboardMappings.zip