I am curious if there is an easier way to paste an exact value into an
adjacent column. Currently, I am using the paste special function but this
is tedious? Is there a keyboard shortcut to do this? For example, column 1
has a value which is derived from a formula (x * 12 months) and I want
columns 2-6 to have the same value as column 1. If you copy and past the
value, it will update the formula for that column. Any advice?