September 24, 2007

How to fix a cell in excel

- Fix a cell in excel
- How do i fix a cell in excel


The secret of excel for fix a cell is $ symbol …
For example, if you want to fix the A1 in formula =B1*A1 then change formula to =B1*A$1.
The $ symbol in a formula tells excel not to use this cell for copy command.

3 comments:

Anonymous said...

Spent ages trying to solve this, your example made it so easy. Thanks

Anonymous said...

thank you very much

Anonymous said...

itwas help ful thanks