![]() ![]() If you want to make the formula constant without changing with the cell, you need to convert the cell references to absolute. ![]() Normally, when selecting a formula cell and dragging it down to fill the cells below, the cell references in the formula will be changed automatically. How to drag or copy formula and lock the cell value in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |