When copying cells, I often need to keep value & formation of the cell but NOT the original formulas.
Copying large range of cells, I couldn't see the
paste icon to choose the associative options. Even though having the icon showed up, it's also a tiring steps.
Would love to have the fastest way possible. Please help.