Hi All,
I have an excel page with formulas, can I confirm how do i copy and paste them as values instead of formula?
Will the typical read and write range works?
Thanks
Victoria
Hi All,
I have an excel page with formulas, can I confirm how do i copy and paste them as values instead of formula?
Will the typical read and write range works?
Thanks
Victoria
Have a check on Copy Range activity setting:
or Modern: what to copy setting
Thanks @ppr . Choosing ‘formula’ under copyitems works if i want to paste the formula on other cells.
However, if I want to copy a cell with formula and paste as values, it appears as 0 when i select ‘value’. Do we have any other options?
“or Modern: what to copy setting” → not exactly sure which activity is this.
Thanks!