Disk Cleaner can Speed Up Your Windows: How to Resolve

Autofill, cell references

Keys to the Problem Autofill, cell references

Hey, I usually drag the formula in the first cell and excel changes the cell numbers/references itself.
But now I am trying to multiply a whole series with a particular cell.ie B1 – B10 with only A1 but auto fill changes the references automatically
- B1 with A1, B2 with A2 & so forth..
How do I do this??
Use $ signs to freeze either the column or row or both.
For example, if you were dragging your formula and you wanted each formula to always reference cell A1 in each new formula, you would use $A$1 and no matter which way you dragged, that reference would
not change.
You do not have to put $ signs on both elements of the address...
it depends on what part you need frozen and which direction you plan to drag the formula.
This is called absolute referencing as opposed to what you do now which is called relative
referencing...
you might want to look these terms up in the help files (or google for them) in order to learn more about them.

And also please do tell what’s the command to run excel from run?
I am not sure what you are referring to here...
can you provide more description please.

Manually editing the Windows registry to fix Error Autofill, cell references

Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

Click the Start button.
Type "command" in the search box... DO NOT hit ENTER yet!
While holding CTRL-Shift on your keyboard, hit ENTER.
You will be prompted with a permission dialog box.
Click Yes.
A black box will open with a blinking cursor.
Type "regedit" and hit ENTER.
In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
From the File menu, choose Export.
In the Save In list, select the folder where you want to save the Windows Operating System backup key.
In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
In the Export Range box, be sure that "Selected branch" is selected.
Click Save.
The file is then saved with a .reg file extension.
You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.