Forum Discussion
How to insert formula into selected cell range (with static value)
Hi, is there any way to insert the same formula to a range of cells that already exist as static value (for example, insert the following "/@INDIRECT(ADDRESS(9,COLUMN()))" to selected cells that cont...
To add on, what I am aiming to do is an efficient way to simply highlight the range of cells where the formula are to be automatically inserted to the back of the original static value (only for cells selected). Thanks!