Sometimes I can copy a range of formulas and then paste it multiple times in
multiple locations on my spreadsheet without having to copy the range before
each pasting. I was doing that during a session I am currently on. Then I
interrupted this to do some other functions within the same spreadsheet. When
I resumed my copying and pasting, I discovered that Excel is now forcing me
to copy the range each time before each paste. This is very time-consuming.
I'd like to know why this is happening and what I can do to eliminate this
needless copying each time.