I have a table where I want to fill a column with a formula but often need to adjust the answers of the formula on per row basis. As a result I started using the “Values for New Rows” feature and than clicking the "apply to __ blank rows " feature in the column format menu in order to calculate the initial fill before I adjust the results down in the table.
This was fine until I started using this trick for more than ~ 6 or 7 columns , when it started to become cumbersome to apply new values.
Is it possible to have a button (or something else) initiate the “apply to __ blank rows” action across a number of columns all at once?
Thanks so much!