- 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.
2 comments:
Spent ages trying to solve this, your example made it so easy. Thanks
itwas help ful thanks
Post a Comment