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.


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